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
encodings.

===

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