RE: [PHP-WIN] String truncate problem of varchar when interfacing with a MS SQL server
| From: | HKG) | Date: | Mon, 30 Sep 2002 11:47:47 +0000 |
| Subject: | RE: [PHP-WIN] String truncate problem of varchar when interfacing with a MS SQL server | ||
| References: | 1 | Groups: | php.windows |
| Request: | Send a blank email to php-windows+get-16071@lists.php.net to get a copy of this message | ||
> I don't know how to work around this problem; is it possible that this is a bug,
> or that I have to run a certain command on the MS SQL before I fetch that variable?
No, its a settings problem for you: default column widths are set to 255 characters.
> If so, which command would it be?
It is for 99% dependent on your data communication/exchange protocol,
which one are you using? ODBC? If so, check out these manual page:
http://www.php.net/manual/en/function.odbc-longreadlen.php
http://www.php.net/manual/en/function.odbc-field-len.php