XPost: microsoft.public.sqlserver.programming   
   From: esquel@sommarskog.se   
      
   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   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)