Posted: 7 Nov 2016 2:44 EST Last activity: 21 Mar 2017 20:44 EDT
Saving Japanese characters in SQL Server database
We have an application where we are saving the user data entered in japanese characters to the SQL Server database. However we observed that the data stored is the db appears as '????' . The type of the column is varchar . Is this an expected behaviour? Any quick changes to the db that could help resolve this issue?
***Updated by moderator: Lochan to add Categories***
I am seeing the same issue at the OOTB table columns like pr_operators.pyPosition, so I could modified to nvarchar but cannot put prefix "N" when saving it. I am not sure it is good idea to modify OOTB table column.