Results 1 to 2 of 2

Thread: Unicode

  1. #1
    Join Date
    Jan 2006

    Unanswered: Unicode

    I know Microsoft SQLServer has UCS / Unicode support. However, I want to know how I check if a database supports Unicode or not.

    Executing sp_helpsort will give you the colation. So you'd get an answer like:
    Latin1-General, case-insensitive, accent-sensitive, kanatype-insensitive, width-insensitive

    How do I know if the DB supports unicode? Is it just a matter it does as long as the columns are defined as n*?


  2. #2
    Join Date
    Mar 2007
    Holmestrand, Norway
    The following are unicode datatypes: nchar, nvarchar, ntext. You may also see string literals which is explicitly written as unicode, by addign a captital N immediately before the string:

    declare @a nvarchar(10);
    set @a = N'Demo';
    And, if you should wonder what the N stands for... National. Nvarchar is an abbreviation for "National Varying Character".
    Ole Kristian Velstadbråten Bangås - Virinco - - Facebook - Twitter

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts