Hey,
we recently migrated from mysql to sql server DB. When testing the new DB, all russian characters now appear as ???.
SQL Sever DB Collation is set to "Latin1_General_100_CI_AS" because when I tried to set it to "Latin1_General_100_CI_AS_UTF8", openkm failed to create database.
If I try to change "NBS_NAME" column's type to nvarchar (saw on google that this might solve the issue), sql server doesnt allow me to do it, and tells me that I should drop the table and create it again. Is this safe to do? I dont have a problem losing data because we still in test phase.
Can you guide me about the topic please?
we recently migrated from mysql to sql server DB. When testing the new DB, all russian characters now appear as ???.
SQL Sever DB Collation is set to "Latin1_General_100_CI_AS" because when I tried to set it to "Latin1_General_100_CI_AS_UTF8", openkm failed to create database.
If I try to change "NBS_NAME" column's type to nvarchar (saw on google that this might solve the issue), sql server doesnt allow me to do it, and tells me that I should drop the table and create it again. Is this safe to do? I dont have a problem losing data because we still in test phase.
Can you guide me about the topic please?