Returning text fields with PHP from MS SQL
| From: | Gard R�dahl | Date: | Thu, 03 Oct 2002 18:26:45 +0000 |
| Subject: | Returning text fields with PHP from MS SQL | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-22190@lists.php.net to get a copy of this message | ||
I get the following error:
"Warning: MS SQL message: 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."
when running a query from the php script.
One of the fields in the table being queried is of a NTEXT type which it has
to be.
How can i work around this problem? I've tried to set the textsize and
textlimit to 65536 in the php.ini file, and run "set textsize 65536" in the
sql query
but I still get the same error message.
Thanks
Gard
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.393 / Virus Database: 223 - Release Date: 30.09.2002