Re: Getting only 255 chars from SQL Server
| From: | Tim Greenleaf | Date: | Tue, 21 May 2002 03:10:13 +0000 |
| Subject: | Re: Getting only 255 chars from SQL Server | ||
| References: | 1 2 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-98620@lists.php.net to get a copy of this message | ||
FYI: MS SQL Server 7 and greater, Varchar is a max of 8000 characters so it
sounds like there is some limitation in the PHP functions that is limiting
this.
"Niklas lampén" <niklas.lists@publico.fi> wrote in message
news:008901c1fa7b$14539d30$ba93c5c3@Niklas...
> 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
>