[freetds] Unicode or ntext-Problem ?

Lowden, James K LowdenJK at bernstein.com
Wed Apr 9 11:38:17 EDT 2003

> From: Frank von Daak [mailto:frank.fun at kpage.de]
> Sent: April 9, 2003 5:46 AM
> I've tried to do a 'select * from ...' on a table with ntext-fields.
> Client: sqsh
> Is it possible, that this does not work with freetds <= 0.61 ?
> Or is it a unicode problem ?
> I get the following error:
> Unicode data in a Unicode-only collation or ntext data cannot 
> be sent to 
> clients using DB-Library (such as ISQL) or ODBC version 3.7 
> or earlier.

I think you are using TDS version 4.2.  Use 7.0 or 8.0 and you'll be able to
select ntext columns.  

We should add this to the FAQ.  Wouldn't it be nice if Microsoft's error
message said something about the TDS version instead of their product

I'd be interested to hear, btw, how well sqsh works with Unicode data with
last night's snapshot (or later).  I haven't gotten around to testing it
yet.  Pretty soon, I hope to see sqsh working with UTF-8 clients.  


The information contained in this transmission may contain privileged and
confidential information and is intended only for the use of the person(s)
named above.  If you are not the intended recipient, or an employee or agent
responsible for delivering this message to the intended recipient, any
review, dissemination, distribution or duplication of this communication is
strictly prohibited. If you are not the intended recipient, please contact
the sender immediately by reply e-mail and destroy all copies of the
original message. Please note that we do not accept account orders and/or
instructions by e-mail, and therefore will not be responsible for carrying
out such orders and/or instructions.

More information about the FreeTDS mailing list