Chinese chars issue in T-SQL

• rajg

  SSChasing Mays

  Points: 631

  More actions

  June 23, 2009 at 2:40 am

  #131452

  Hi All,

  I have problem with chinese characters in TSQL. If I excute following code block, it displays characters as '????????'

  DECLARE @result nvarchar(max)

  SET @result = '나노솔루션테크'

  PRINT @result

  How do I make sure that chars are displayed correctly for further processing?

  Also it could be chinese or korian or japanese.

  Any help would be appreciated.

  Thanks,

  Bhimraj

• Pandian S

  SSChasing Mays

  Points: 625

  More actions

  June 23, 2009 at 3:52 am

  #1013809

  It will work

  DECLARE @result NVARCHAR(MAX)

  SELECT @result = N'???????'

  PRINT @result

  (Or)

  DECLARE @result NVARCHAR(MAX)

  SELECT @result = N'???????'

  PRINT @result COLLATE Chinese_PRC_CI_AI

• rajg

  SSChasing Mays

  Points: 631

  More actions

  June 23, 2009 at 4:07 am

  #1013812

  THANK you sathappanpandian !!

  --Bhimraj

• kapilsharma1978

  Valued Member

  Points: 55

  More actions

  October 8, 2014 at 6:01 am

  #1750902

  but how to pass in stored proc

• Ed Wagner

  SSC Guru

  Points: 287026

  More actions

  October 8, 2014 at 6:28 am

  #1750918

  Declare your parameter as nvarchar and then be sure to pass an nvarchar value when calling it.

  Tally Tables - Performance Personified
  String Splitting with True Performance
  Best practices on how to ask questions