Problems with SQL Server and nText fields
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
|