DirectConnect for Microsoft SQL Server

Following are issues pertaining to Microsoft SQL Server.


NCHAR and NVARCHAR datatype support

Microsoft NCHAR and NVARCHAR datatypes are not supported but are translated to the single-byte character set of the operating system. Unicode characters that cannot be mapped are translated to a default character for the operating system.


Service Pack version

If your Microsoft SQL Server 2000 is not at Service Pack 3 or later, set QuotedIdentifiers=yes for the DSN entry for accessing Microsoft SQL Server.