String truncated while retrieving from MS SQL DB

Anon

I have a huge problem.
I created a MS SQL database with a table containing varchar(1000) data.
There is no problem with that (you can declare up to 5000).

But when I query my db (using mssql_fletch_array or any other function) it retrieves only the first 255 character of my fileld.

Anyone has an idea ?

Thanks a lot.

Anon

Have you actually gone into your database and checked to make sure the data is in tact within the fields. I was under the impression that varchar is limited to 255

Anon

Yes I checked that with enterprise manager and my fields contains all my data. SQL SERVER tell me that varchar is limited to 4000 characters. So I think it s ok. It could be a driver setting to enable query to return more than 255 charcters but if so I don't know how to do that I tryed "set textsize 1000" but it the same.

Is anybody manage to get more data from a query.
Help please.

Anon

Have you tried using the ODBC functions instead. Might be a MS SQL library deficiency in PHP.

I have never heard of what you are seeing, but then again I have never tried it either.

Just a suggestion.

Anon

Yeah you were right Chris, this is a bug in MS SQL library. I converted my conection class to use odbc driver and it works fine.
Thanks for all.

Cheers.

Anon

Just for the record, I'm having the exact same problem.

Excellent resource. Thanks for the help!

Mark