MS SQL / PHP truncating result text

Question

I have a MS SQL query that selects a field and is chopped off, for some reason it disables text with 257 characters.

Is there some default restriction for getting results with MSSQL and PHP?

I honestly don’t know why this is happening. ANY leadership will be highly appreciated

Field type "char"

Here is a screenshot of my MS SQL configuration from phpinfo() alt text http://www.aaacoloautosource.com/mssql_config.png

can this be a value mssql.textlimitor mssql.textsize?

Answer 1

- "char", , -, 255 . 255 .

TEXT - .

SELECT CONVERT(TEXT,fld_name) FROM TABLE_NAME

Answer 2

, , , TDS 4.2. 7.0, /etc/freetds.conf:

tds version = 7.0

4.2:

• ASCII
• RPC .
• BCP .
• varchar 255 . , .
• ( ) .

. http://freetds.schemamania.org/userguide/choosingtdsprotocol.htm

Answer 3

mysql:

CHAR , . 0 255.

In my MYSQL version, I cannot set the CHAR field up to 255 characters long as above.

Is there a reason you need to use char? Instead, try using text or blob or varchar.