IIRC this is a known problem with the native php SQL Server APIs which were built 
using the original TDS drivers based on v6.x of SQL Server which did not support 
NVARCHAR data types... if you can't change the datatype to TEXT then try a cast. 
Failing that does it work if you use ODBC instead?


-----Original Message-----
From: Adam Voigt [mailto:[EMAIL PROTECTED]]
Sent: 10 December 2002 15:18
Subject: [PHP-DB] MSSQL Text Length Restriction

I can't seem to get more then 255 characters to be sent back from a field 
in our MSSQL database, unless the fields is a "TEXT" type, which is very 
inefficient. Anyone know a fix? (I've already tried modifying the max size 
variables in the php.ini under the MSSQL section.) 
The Cryptocomm Group
My GPG Key:

PHP Database Mailing List (
To unsubscribe, visit:

Reply via email to