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: [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 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
