We have a long standing problem pulling data from ntext fields in a
server running MSSQL 2000, which i always assumed was a problem with
freetds and or DBD::Sybase.
However, I've actually done some investigation today, and i've
discovered that the particular code that's causing problems actually
runs fine at the command line, as well as under plain CGI. However,
it blows up when running in mod_perl. I'm about to attempt to reduce
this down to a simple case, but if anyone has any ideas, i'd love to
here them.
basically what happens is whenever i run a query that pulls an ntext
field, i get this:
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.
the freetds.conf for the DB is like this:
[clients]
host = ...
port = 1433
tds version = 8.0
client charset = CP1252
We're running freetds 0.64, and DBD::Sybase 1.08.
Any ideas would be appreciated (and no i can't just change the fields
to not be ntext)
Adam
