SQL Server Performance Forum – Threads Archive
How to Store Japanese KANJI Characters
I would like to know how to Store Japanese KANJI Characters in SQL Server Table and when I BCP it out to a txt file it should show the same value.
read collations [SQL Server] in BOL. You can have different collation at various level like Database/Table/Column etc. Madhu
SQL Server supports storing UTF data in this case where it supports only UTF-16 base, and as explained the database can have different collations to different columns like japanese_text nvarchar(23) COLLATE Japanese_xx_xx and also look for BOL about width and kana-sensitive variations in this case. Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
This posting is provided AS IS with no rights for the sake of knowledge sharing.