How to display Japanese Characters through C# code

• kk-479046

  SSC Eights!

  Points: 903

  More actions

  August 11, 2009 at 3:57 pm

  #103797

  Hi,

  I have some nvarchar fields in the backend, and these store some Japanese characters along with English characters.

  When I try to retrieve this using a string variable in C#, the Japanese characters are displayed as "?" . How could i get the right display?

  Thanks,

  KK

• Gift Peddie

  SSC Guru

  Points: 73570

  More actions

  August 11, 2009 at 5:19 pm

  #1037783

  There are two options if the Japanese is stored in a separate column you could change the collation to the version of Japanese you are getting from the database and use the collation in your T-SQL code. If both Japanese and English are stored in one column then you need collation precedence. Run a search for collation precedence in the SQL Server BOL.

  Kind regards,
  Gift Peddie