[RESOLVED] Problem with big string query

allanforever

😕 I'm having a problem when i try to get a big string field [varchar(2000)] with mssql_fetch_row... the field return only the first 256 characters from database. Can someone help me?

laserlight

Could it be that 255 is the maximum length allowed for varchar?

allanforever

laserlight wrote:
Could it be that 255 is the maximum length allowed for varchar?

No, in the database the string is longger than 256... some rows have more than 1000... the output is the problem. php.ini have some feature that configure max_length of queries or something like this?

laserlight

Ah, apparently there is an API limitation, according to the user notes at the PHP manual. A workaround suggested is:
SELECT CAST([field] AS TEXT) FROM [table]

Of course, a possibly better alternative is to use TEXT instead of VARCHAR(2000) in the first place.

allanforever

i can't try use this rigth now, but i will this afternoon...
thanks 😉

allanforever

laserlight wrote:
Ah, apparently there is an API limitation, according to the user notes at the PHP manual. A workaround suggested is:
SELECT CAST([field] AS TEXT) FROM [table]

Of course, a possibly better alternative is to use TEXT instead of VARCHAR(2000) in the first place.

OK, thanks a lot!!!!😉
This solution solve my problem!!!!😃
If someone want to try something else there is two properties in php.ini called "mssql.textlimit" and "mssql.textsize".
I can't change php.ini because i don't have permission.
the CAST function worth pretty well!!!