RE: [PHP-DB] Fields containing long text and ODBC

Hi Ville, Most likely your datatype is one that has a max size of 256 characters, but your database didn't enforce that limit when inserting. Since ODBC queries the attributes of the database when querying, it's being told that the field should only return 256 characters and is truncating anything after that. Try using a MEMO, TEXT, etc., field, or NVARCHAR, etc. that will allow a greater fill. Best regards, Andrew ---------------------------------------------------- Andrew Hill Director Technology Evangelism OpenLink Software http://www.openlinksw.com XML & E-Business Infrastructure Technology Provider > -----Original Message----- > From: Ville Mattila [mailto:ville.mattila@pilotmedia.net] > Sent: Saturday, November 18, 2000 4:59 PM > To: php-db@lists.php.net > Subject: [PHP-DB] Fields containing long text and ODBC > > > Hello there, > > I have a small problem with reading data over ODBC connection > from columns containing much text. There is a product database > and one field includes some description about the product. The > description is normally about 400 charters, and PHP cuts them > always down to 255 charters. What's the matter? > > Thanks, > - Ville > > ............................................. > Ville Mattila > Ikaalinen, Finland > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net > For additional commands, e-mail: php-db-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net > > >