Thursday, August 30, 2012 1:57 PM
SSMS has stopped displaying chinese characters correctly.. instead it shows lots of small boxes. When I copy and paste the data it appears correctly. Yesterday it was working ok.
Thai characters are still appearing correctly.
The database collation is: SQL_Latin1_General_CP1_CI_AS
When i print the results everything is ok... It is something to do with results to grid.
It it the same problem as in http://serverfault.com/questions/242470/sql-server-management-console-doesnt-work-with-multi-byte-characters but the suggested fix does not work on my PC.
Can anybody help
Monday, September 03, 2012 3:37 AMModerator
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.
Monday, September 10, 2012 9:23 AM
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:
Tuesday, September 11, 2012 10:40 PM