Re: Getting only 255 chars from SQL Server

Varchar can only be set to a maximum of 255 Try setting the column to long text "Unknown Sender" <bogus@news.php.net> wrote in message news:3CDF1A53.5060605@highlanderdesign.com... > 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. If I use a SQL client to check the db, I see that all 800 > characters are there. And if I use ASP pages I can get all 800 > characters returned on the web page, but using php only gets the first > 255. I used some php column length functions on the page and it shows > those 4 fields as length 255.(??) > Am I missing something? Does php have a limit on the number of > characters returned from a field? I can use ASP to write the pages I > guess, but I don't know why php wouldn't work. > > Thanks, > Dave >