[unixODBC-dev] unicode troubles

Daly, Fergal fergal.daly at accpac.com
Fri Jul 16 11:46:31 BST 2004

Just for the record, the solution to my problem was to set the TDS version
to 8.0 (7.0 should also work). It defaults to 4.2 and that doesn't seem to
handle long strings very well or Unicode at all,


-----Original Message-----
From: Daly, Fergal [mailto:fergal.daly at accpac.com]
Sent: 15 July 2004 17:40
To: unixodbc-dev at mail.easysoft.com
Subject: [unixODBC-dev] unicode troubles


not sure if this is a unixODBC or FreeTDS problem but it appears to unixODBC
at first glance.

I'm selecting from an NCHAR column on an MS SQL server and I'm getting

[FreeTDS][SQL Server]Unicode data in a Unicode-only collation or ntext data
cannot be sent using DB-library (such as ISQL) or ODBC version 3.7 or

I'm using unixODBC 2.2.9 and FreeTDS 0.62.4.

Is there something I have to do before I can retrieve unicode data?


More information about the unixODBC-dev mailing list