RE: [PHP-DB] MSSQL Text Length Restriction

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 Jeffrey N Dyke To: Adam Voigt <adam@cryptocomm.com> 12/10/2002 cc: php-db@lists.php.net, "Hutchins, Richard" 10:43 AM <Richard.Hutchins@GetingeCastle.com> Subject: RE: [PHP-DB] MSSQL Text Length Restriction(Document link: Jeff Dyke) this little snippet works for me. mssql_query("set textsize 65536"); HTH Jeff Adam Voigt <adam@cryptoco To: "Hutchins, Richard" <Richard.Hutchins@GetingeCastle.com> mm.com> cc: php-db@lists.php.net Subject: RE: [PHP-DB] MSSQL Text Length Restriction 12/10/2002 10:35 AM Ok, my question was in reguards to Microsoft SQL (MSSQL), you are referering to MySQL. On Tue, 2002-12-10 at 10:21, Hutchins, Richard wrote: Look at the tinyblob (tinytext), mediumblob (mediumtext), blob (text), longblob (longtext) column types in the MySQL manual. Storage-wise they don't look too terribly inefficient. -----Original Message----- From: Adam Voigt [mailto:adam@cryptocomm.com] Sent: Tuesday, December 10, 2002 10:18 AM To: php-db@lists.php.net 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.) -- Adam Voigt (adam@cryptocomm.com) The Cryptocomm Group My GPG Key: http://64.238.252.49:8080/adam_at_cryptocomm.asc -- Adam Voigt (adam@cryptocomm.com) The Cryptocomm Group My GPG Key: http://64.238.252.49:8080/adam_at_cryptocomm.asc