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: 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