RE: [PHP] Getting only 255 chars from SQL Server
| From: | Niklas Lampén | Date: | Mon, 13 May 2002 12:38:26 +0000 |
| Subject: | RE: [PHP] Getting only 255 chars from SQL Server | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-97342@lists.php.net to get a copy of this message | ||
The platform doesn't matter here, since VarChar's maximum length is 255
chars, so everything above that is cutted away on insert.
Creating table with VarChar(800) should give an error..
Niklas
-----Original Message-----
From: Michael Sims [mailto:mhsims@midsouth.rr.com]
Sent: 13. toukokuuta 2002 15:32
To: php-general@lists.php.net
Subject: Re: [PHP] Getting only 255 chars from SQL Server
On Sun, 12 May 2002 18:43:47 -0700, you wrote:
>I have an SQL Server database running on a server on the internet. I
>need to have php connecting to the db and returning values. Simple
>stuff. No problem making the connection and getting data using the
mssql
>functions. The weird thing is that 4 of the fields in the table are
>vchar fields of length 800. When getting the data from the db for the
>web page, all that gets returned are the first 255 characters of each
>field.
Are you using FreeTDS on *nix, or is this a Windows server making the
connection?
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php