Does SQL Server support Unicode?

A. With SQL Server 7.0 and above full UCS-2 Unicode support is there. There is no Unicode support in 6.5 and earlier (you had to use dbcs).

UCS-2 is the official Unicode two-byte definition for all characters. Some DBMS manufacturers have only implemented a space-conserving, pseudo-form of Unicode, UTF-8, which has mixed one-byte and two-byte


v1.01 2000.02.02
Applies to SQL Server versions : 7.0
Related FAQ articles : Q232580
Related Microsoft Kb articles : n/a
Other related information : n/a

Hide comments


  • Allowed HTML tags: <em> <strong> <blockquote> <br> <p>

Plain text

  • No HTML tags allowed.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Lines and paragraphs break automatically.