MSSQL : Retrieving ntext fields

[lobobr]

Greetings.

I'm trying to retrieve ntext fields from a MSSQL db.

My code gets the values from these fields and generates a JavaScript with them, for client-side processing.

My JS is generating an error, because I'm trying to retrieve a ntext > 255 chars. I've took a look at php.net and tried the following:

1) added: mssql_query("set textsize 8000"); to my code
2) changed: mssql.textlimit and mssql.textsize value to same above

None of these solutions worked. I know this is not a JS error because if I tell PHP to get only one or two values that are < 255 chars the page works fine.

Can anyone help me with this?

Thanks in advance,

Er Galvão Abbott
Developer

[flipis]

The only advice i can give to you is this. Don't use mssql functions. I tried, but found out odbc were much more useful.

Hope it helps

fLIPIS

P.D: You still have to use set_textsize with odbc_*

[lobobr]

Problem is I'm not using an ODBC connection. I'm connecting through mssql_connect...

Isn't there any workaround?

[Anon]

Yes, use odbc_connect. Otherwise, i can't help you. I don't really know about this VERY WEIRD thing with ntext fields.

Sorry

fLIPIS