RE: [PHP-DB] Fields containing long text and ODBC From: Andrew Hill (ahill <email protected>)
Date: 11/20/00

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 <email protected>]
> Sent: Saturday, November 18, 2000 4:59 PM
> To: php-db <email protected>
> 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 <email protected>
> For additional commands, e-mail: php-db-help <email protected>
> To contact the list administrators, e-mail: php-list-admin <email protected>
>
>
> 

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: php-db-unsubscribe <email protected>
For additional commands, e-mail: php-db-help <email protected>
To contact the list administrators, e-mail: php-list-admin <email protected>