A long time ago I had this problem and discovered a checkbox in the ODBC configuration wizard with NT where you could specify how many chars of a varcar to return...
you might look there... On Mon, 20 May 2002, Tim Greenleaf wrote: > 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" <[EMAIL PROTECTED]> wrote in message > 008901c1fa7b$14539d30$ba93c5c3@Niklas">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:[EMAIL PROTECTED]] > > Sent: 13. toukokuuta 2002 15:32 > > To: [EMAIL PROTECTED] > > Subject: Re: 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 > > > > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
