PHP & MS SQL, text truncated

[surf741]

Hello,
I have a problem when querying a varchar texfield form an MS SQL database. although the data is stored correctly in the database, it is truncated after about 256 chars from the beginning when receyved by PHP. The PHP directives mssql.textlimit and mssql.textlimit mssql.textsize are both set to 4096.

I go wild about this. Can anybody please help me?

mark

[Wien]

Of course because "You can declare a VARCHAR column to be any length between 1 and 255"
This is actually true with Mysql but I guess it's exactly the same with Mssql.
So if you want to store a longer string you can use TEXT type which can store up to 2¹⁶ char... must be enough

[Wien]

Sorry I confused with Msql, and you use Microsoft SQL, right ?
So it's true you can handle long varchar, such as varchar(1000)...

I don't know sorry 😉

[surf741]

..otherwise, the data wouldn't show up correctly in the databse, I think. but thanx for the try.

mark

[magmy]

Originally posted by surf741
I have a problem when querying a varchar texfield form an MS SQL database. although the data is stored correctly in the database, it is truncated after about 256 chars from the beginning when receyved by PHP. ...

I have experienced the same problem, and I just found a solution to it.

PHP's MSSQL supports updating tables with strings with more than 255 characters.

However, retrieved strings will be truncated to 255 characters if the corresponding table field is of type char or varchar.

Solution 1: Define your SQL long string database fields using text.

Solution 2: Trick the MSSQL DB library into believing that it receives a text when it is actually receiving a char or varchar string. Example:

$result = mssql_query("select convert(text, S) as S from T, $connection);