CODEWITHSUNDEEP
phpsqlsql-servert-sql
Toby Allen
Toby Allen

Reputation: 11213

How do I stop MSSQL truncating text when accessed from php?

When I try to retrieve the contents of a Text field from mssql in php I only get back part of the contents. I think its about the first 4000 characters.

How do I stop this.

Upvotes: 0

Views: 306

Answers (1)

Toby Allen
Toby Allen

Reputation: 11213

Answering my own question

Find this section of your php.ini file and change to the values below.

; Valid range 0 - 2147483647. Default = 4096. 
mssql.textlimit = 2147483647 

; Valid range 0 - 2147483647. Default = 4096. 
mssql.textsize = 2147483647

Upvotes: 3

Related Questions