View Single Post
  #1 (permalink)  
Old 10-18-2007, 11:10 PM
clone45 clone45 is offline
Junior Member
 
Join Date: Jul 2007
Posts: 11
Default 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
Reply With Quote