Adam 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? Rich -----Original Message----- From: Adam Voigt [mailto:adam@cryptocomm.com] Sent: 10 December 2002 16:01 To: Jeffrey_N_Dyke@Keane.com Cc: php-db@lists.php.net Subject: RE: MSSQL Text Length Restriction Uncommented, and set to the max value (2147483647). No effect. On Tue, 2002-12-10 at 10:57, Jeffrey_N_Dyke@Keane.com wrote: Adam. are these lines uncommented in your php.ini? They are under [MSSQL] ; Valid range 0 - 2147483647. Default = 4096. ;mssql.textlimit = 4096 ; Valid range 0 - 2147483647. Default = 4096. ;mssql.textsize = 4096 sorry, i'm not replying to the other email. i deleted it accidentally -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php