Field length too short when results pulled from mmsql

[wonderx]

I'm using MS SQL server using PHP with OBDC.
I have a varchar field in a table which is 8000 characters long but when I put it on the page using it truncates it to 255 characters! I view the datatype using PHP, it say : stdClass Object ( [name] => intro_text [max_length] => 255 [column_source] => intro_text [numeric] => 0 [type] => char ).

Does anyone know how too increase it or make the query show the whole length of the field ie 8000 characters.

Grateful for the help.

WonderX.

[br__ken]

try using text/longtext/mediumtext instead of varchar, i think varchar/char have a max limit of 255 while long/medium/text have well over 1k (their exact values are easy to find)

[[deleted]]

[the following has basically been taken straight from user notes in the php.net manual]
first run this query :

mssql_query("set textsize 65536");

then you need to use the convert function. So if you had a query that looked like:

$SQL="select UserID, UserComments from WebComments where UserID=100";

change it to:

$SQL="select UserID, convert(text,UserComments) as UserComments from WebComments where UserID=100";

Hope that helps....

[netbros]

I've had the same problem with MS-SQL...

Any field set with varchar(>255) returns only 255 characters - no more!

I tried converting the field to text, but it only seems to return max 3000 characters. Here, though, I'm not sure if I'm saving the data correctly as I have no way to verify it.

Any suggestions?

Also, for the MS-SQL gurus out there, how do I set the date format to return as YYYY-MM-DD HH:MI:SS without resorting to calling the CONVERT() function on every date field -- any ideas?

Muchos Gracias! 🙂

-- J