Path: csiph.com!x330-a1.tempe.blueboxinc.net!newsfeed.hal-mli.net!feeder1.hal-mli.net!feeder.news-service.com!85.214.198.2.MISMATCH!eternal-september.org!feeder.eternal-september.org!.POSTED!not-for-mail From: Erland Sommarskog Newsgroups: comp.databases.ms-sqlserver,microsoft.public.sqlserver.programming Subject: Re: SSE 2008: Testing Unicode Followup-To: comp.databases.ms-sqlserver Date: Tue, 26 Apr 2011 07:15:24 +0000 (UTC) Organization: Erland Sommarskog Lines: 33 Message-ID: References: Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Injection-Date: Tue, 26 Apr 2011 07:15:24 +0000 (UTC) Injection-Info: mx02.eternal-september.org; posting-host="G7+Jz22XqYCG8C6rb1H3YA"; logging-data="22533"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX18uFXkdWxxhaHEihXnPyHIz" User-Agent: Xnews/2005.10.03 Mime-proxy/1.4.c.4 (Win32) Cancel-Lock: sha1:CABopEVHYSowFPAxNBRqHwtKreQ= Xref: x330-a1.tempe.blueboxinc.net comp.databases.ms-sqlserver:218 Gene Wirchenko (genew@ocis.net) writes: > I think I have just managed to enable Unicode on my Windows XP > system. Some stuff does not seem to be displaying correctly. Some > has. Maybe I am missing a bit? > > I found a lorem ipsum page for Russian, and a couple of > paragraphs of that worked fine. Only some Russian characters from the > Wikipedia page on Unicode worked. > > Does anyone know of a good test for Unicode? If it also applies > directly to SQL Server, so much the better. Jeroen said most of it - you need a good font to see all characters. Arial or Times Roman should do. I don't remember, maybe there are some options when you install XP - it was so long ago. If you see block characters where you expected to see something else, that means that the font is insufficient. If you see question marks, it means that there was conversion of some sort, and the character was converted to a fallback character. Anyway, for SQL Server the important thing to keep in mind that character literals like this: 'abc' are always varchar, not matter what exotic characters you put in it. You need to say N'abc' to get a nvarchar (i.e. Unicode) literal. -- Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se Books Online for SQL Server 2005 at http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx Books Online for SQL Server 2000 at http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx