Hello! Sorry for all the questions. I'm trying to do a very simple query against a SQL Server database. The application that I'm creating must be able to access a client's old data. Here's the query:

$sql = "SELECT * FROM Communities";
$results = $this->db->fetchAll($sql);

This is throwing an error message:

General error: 10007 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 Communities table contains a few ntext fields, which seem to be triggering the error. If I change the query to avoid selecting the ntext fields (SELECT Name FROM Communities), it works just fine. How does one work around this?

Thanks!
- Bret

I've had this problem before. I was using linux and freetds, and the tds version I was using for the DB host was too old. You should have something like this in your freetds.conf:

The 'tds version' line is the most important. If you don't specify a version for a specific host, your system will use the [global] configuration declared in your freetds.conf, which usually uses a much older tds version.

Thanks. I also learned that if I converted the fields from nText to just Text, that should solve the issue as well.

Converting the fields from nText to Text will work around the problem if you don't want to store any unicode characters in those fields.