Issues with the Russian language
PostPosted:Fri Feb 23, 2024 3:42 am
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?
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?