Question

8
Replies
461
Views
BinodG81 Member since 2014 35 posts
Infosys
Posted: 3 years ago
Last activity: 3 years 6 months ago
Closed

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***

Data Integration
Close popover
Moderation Team has archived post
Posted: 3 years ago

Gangababu,


This is is SQL Server database and not oracle. In SQL Server we have collations defined .

Posted: 3 years ago

HI Binod,


Try updating column to nvarchar from varchar.


Once this is done values while inserting or updating should be prefixed with N


eg Update tableX set y = N'JapaneseCharacter' where condition.


Above will help you verify if DB is accepting Japanese character.


Raise an SR in case not done yet.


 


Thanks,


Ujjwal


 


 

Posted: 3 years ago

Hi Binod, 


I am facing the same issue. Do you have a resolution on your side? 


Thanks, 


Jun

Posted: 3 years ago

Hi Jun,


As stated above have you modified to nvarchar from varchar and also when doing your insert or update, are you prefixing your value with N at the front?


Regards,


Shanthini Charles

Posted: 3 years ago

Hi Shanthini, 


Thank you for your response. 


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. 


 


Regards, 


Jun


 


 
Share this page LinkedIn
Copied!