MS SQL/PHP truncating result text

Question

I have a MS SQL query that is selecting a field and it is being chopped off for some reason it is cutting off text at 257 characters.

Is there some kind of default cut-off for retrieving results with MSSQL and PHP?

I'm honestly clueless as to why this is happening. ANY guidance would be greatly appreciated

The field type is "char"

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

could it be the mssql.textlimit or mssql.textsize value?

How big can a char field be? Is it char(255) or something? The number 257 is suspiciously close to 256 == 2^8 — user354134
– user354134, Commented Jun 2, 2010 at 16:59

Derek Adair · Accepted Answer · 2010-06-02 21:30:01Z

2

Somehow the datatype is "char", which apparently is limited to 255 characters. BUT the DB is storing more than 255 characters.

Converting the field to TEXT works perfectly for some reason.

SELECT CONVERT(TEXT,fld_name) FROM TABLE_NAME

answered Jun 2, 2010 at 21:30

Derek Adair

22k31 gold badges101 silver badges134 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

David Sickmiller · Accepted Answer · 2012-11-11 15:36:36Z

1

The problem is most likely that you are using TDS protocol version 4.2. You should upgrade to at least 7.0 by setting this in /etc/freetds.conf:

tds version = 7.0

The limitations of version 4.2 are:

ASCII only
RPC is not supported.
BCP is not supported.
varchar fields are limited to 255 characters. If your table defines longer fields, they'll be truncated.
dynamic queries (also called prepared statements) are not supported.

For more details, see http://freetds.schemamania.org/userguide/choosingtdsprotocol.htm

answered Nov 11, 2012 at 15:36

David Sickmiller

1,2559 silver badges8 bronze badges

Comments

Rupert Madden-Abbott · Accepted Answer · 2010-06-02 19:43:19Z

-1

From the mysql manual:

The length of a CHAR column is fixed to the length that you declare when you create the table. The length can be any value from 0 to 255.

In my version of MYSQL, I cannot set a char field to longer than 255 characters, as per the above specification.

Is there any reason you need to use char? Try using text or blob or varchar instead.

answered Jun 2, 2010 at 19:43

Rupert Madden-Abbott

13.4k17 gold badges63 silver badges81 bronze badges

Collectives™ on Stack Overflow

MS SQL/PHP truncating result text

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related