Re: SQL Server and Unicode

From: Michael \(michka\) Kaplan (
Date: Wed Jul 26 2000 - 05:53:01 EDT

SQL Server supports the datatypes NTEXT, NCHAR, and NVARCHAR, all of which
are of type UCS-2. When such a column indexed, then the index is Unicode (I
am not sure if this what you mean).

SQL Server 7.0 only supports one language collation at the server level....
this choice affects the actual ordering of all such indexes.

SQL Server 2000 supports a COLLATE keyword that allows you to specify a
collation at the database or field level and thus choose a different
language for such columns/indexes if you like (I discuss practical details
and implications of this feature in an upcoming article in the Visual Basic
Programmer's Journal, tentatively scheduled for November).

In any case, you can certainly query and such field in either SQL 7.0 or in
SQL 2000.

Hopefully this answers your question; if not, let me know. :-)


----- Original Message -----
From: "pierre vaures" <>
To: "Unicode List" <>
Sent: Wednesday, July 26, 2000 1:23 AM
Subject: SQL Server and Unicode

> To Whom It May Concern:
> SQL server is in the Unicode Products WebSite described as Unicode
> What we would like to know is :
> a - Does SQL Server allows to set as an index a field in Unicode standard?
> b - Can you make SQL query on this particular field?
> If you have any information, or ideas, thanks for your help.
> Regards,
> Pierre

This archive was generated by hypermail 2.1.2 : Tue Jul 10 2001 - 17:21:06 EDT