mxODBC SQL Type error with MS SQL Server

Bill Tutt billtut at
Fri Mar 31 10:47:15 CEST 2000

> From: M.-A. Lemburg [mailto:mal at]

> BTW, does anyone have a pointer to the specifications
> behind the Unicode support in SQL Server or the latest
> ODBC variant ?

SQL Server 7 specific details:

Unicode constants are desginated by a N'A Unicode string' in the query
The datatypes in SQL Server are: nchar, nvarchar, and ntext.
All of these are UTF-16 data fields. (machine endian)
As far as handling collation issues:

SQL Server 7 requires that character set, sort order, and Unicode collation
be specified on a per server basis.

The details on Unicode collation support can be found at:

The ODBC C Unicode datatypes is:

The ODBC SQL datatypes are:

The ODBC API also uses UTF-16.

For more info on the ODBC stuff:


More information about the Python-list mailing list