SSMS has stopped displaying chinese characters correctly

All Replies

• Monday, September 03, 2012 3:37 AM

  Moderator

   

   
  

  0

  Hi Mr Shaw,

  I did a similar test, and it could display Chinese characters correctly. I’m using SQL Server 2008 R2 SP1 and the database collation is SQL_Latin1_General_CP1_CI_AS. How did you encounter this issue? Maybe you could try to repair the SQL Server and then check if it could work.

  
  Best Regards,
  Ray Chen

  
  

  • Edited by Shulei ChenModerator Monday, September 03, 2012 3:37 AM
  • Proposed As Answer by Shulei ChenModerator Friday, September 07, 2012 9:38 AM
  • Unproposed As Answer by Shulei ChenModerator Friday, September 07, 2012 9:38 AM
  •  
  • Reply
  • Quote

   
• Monday, September 10, 2012 9:23 AM

   

   
  

  0

  I've just seen the same problem.

  The test text looks fine in the editor window (SSMS 2012 on Windows 8), and in the output if set to "Results in text", but if set to "Results in grid" the text appears as boxes.

  I've set the font for "Text Editor" and "Grid Results" to various different fonts, including "Segoe UI" and "Consolas" - all work in the editor, none in grid view.

  This is my sample query:

  DECLARE @bulgarian AS nvarchar(100) = N'Честита Нова Година!'
  DECLARE @chinese AS nvarchar(100) = N'新年快樂'
  DECLARE @arabic AS nvarchar(100) = N'سنة جديدة سعيدة!'
  DECLARE @armenian AS nvarchar(100) = N'Շնորհավոր Նոր Տարի'
  DECLARE @azarbaijani AS nvarchar(100) = N'Yeni iliniz mübarək'
  DECLARE @catalan AS nvarchar(100) = N'Feliç Any Nou!'
  DECLARE @polish AS nvarchar(100) = N'Szczęśliwego Nowego Roku!'
  DECLARE @thai AS nvarchar(100) = N'สวัสดีปีใหม่'
  DECLARE @hindi AS nvarchar(100) = N'नया साल मुबारक हो'
  
  SELECT Languange='Bulgarian', Sample=@bulgarian UNION ALL
  SELECT 'Chinese', @chinese UNION ALL
  SELECT 'Arabic', @arabic UNION ALL
  SELECT 'Armenian', @armenian UNION ALL
  SELECT 'Azerbaijani', @azarbaijani UNION ALL
  SELECT 'Catalan', @catalan UNION ALL
  SELECT 'Polish', @polish UNION ALL
  SELECT 'Thai', @thai UNION ALL
  SELECT 'Hindi', @hindi

  And here's a grid result:

  

  And a text result:

  

  • Reply
  • Quote

   
• Tuesday, September 11, 2012 10:40 PM

   

   
  

  1
  Results to grid looks good in SQL 2012.

  ---

  Anup | Database Consultant

  Blog: www.sqlsailor.com Twitter: Follow me !

  Please use Mark as Answer if my post solved your problem and use Vote As Helpful if a post was useful.

  • Reply
  • Quote