Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.databases.ms-sqlserver > #218

Re: SSE 2008: Testing Unicode

Cross-posted to 2 groups.

Followups directed to: comp.databases.ms-sqlserver

Show all headers | View raw

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

Back to comp.databases.ms-sqlserver | Previous | Next — Previous in thread | Find similar

Thread

SSE 2008: Testing Unicode Gene Wirchenko <genew@ocis.net> - 2011-04-25 15:38 -0700
  Re: SSE 2008: Testing Unicode Jeroen Mostert <jmostert@xs4all.nl> - 2011-04-26 06:35 +0200
  Re: SSE 2008: Testing Unicode Erland Sommarskog <esquel@sommarskog.se> - 2011-04-26 07:15 +0000

csiph-web