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
Applies to SQL Server versions : 7.0
Related FAQ articles : Q232580
Related Microsoft Kb articles : n/a
Other related information : n/a