Re: Re: MSSQL varchar fields truncation revisited

MySQL and MSSQL is two different databases ! MSSQL 7.0 can handle varchar columns larger than 255, but the C-API used to fetch the data does not support this feature and therefore PHP is limited to fetch only the first 255 characters. The only solution (so far) is to convert to TEXT. - Frank > i was under the impression that varchar fields in mysql had a limit of 255 > characters. if this is true, then there is no bug and the only real > workaround is to change the field type. i could be wrong, check the mysql > manual. good luck... > > Dan > > +-------------------------------------------------------------------+ > | | > | If Yoda so strong in force is, | > | why words in proper order he cannot put? | > | | > +-------------------------------------------------------------------+ > | | > +-------------------------------------------------------------------+ > | Daniel J. Cleveland | > | e-mail: dclevela@cnavsystems.com| > +-------------------------------------------------------------------+ > > > > -- > PHP Windows Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-windows-unsubscribe@lists.php.net > For additional commands, e-mail: php-windows-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net > > >