Issues with the Russian language

[ulnaoperating]

Excuse me,

We switched from MySQL to SQL Server for our database not long ago. All Russian characters now show up as??? while testing the updated database.

I set the SQL Server DB Collation to "Latin1_General_100_CI_AS" since openkm failed to build the database when I tried to set it to "Latin1_General_100_CI_AS_UTF8."

I found on Google that changing the type of the "NBS_NAME" column to nvarchar could fix the issue, however SQL Server won't let me do that and instead says I need to delete the table and create it again. It seems risky. We are currently in the testing process, thus data loss is not an issue for me.

Would you be so kind as to help me with this subject?

[jllort]

We do not suggest using SQL Server for several reasons ...
Anyway, if you have chosen a bad collation for your database the only option is to start again from a clean database -> export all the data, and import again in a fresh database ( do some tests before importing the data to ensure characters etc... are set fine )