All geek questions in one place

Data ends with 64512 characters - MSSQL // PHP // OPENSuSE // APACHE2

I am connecting to mssql db on Windows Server using the FREETDS driver for Linux via PHP.

The web server on which the application is running when OPENSuSE is launched, Apache2 with PHP, FreeTDS drivers for connecting to the Windows window in which it works.

I can execute the stored procedure and view the data that it produces, but the output for each array value seems to stop at 64512 bytes (tested using strlen in PHP) - is this a problem on the PHP side or the MS side? Does anyone know how I can fix this?

+3
source share
2 answers

Have you checked your configuration file and increased the text size? See FAQ

1> set textsize 10000 2> go

See also text size option in freetds.conf

+5
source

Or you can add these values ​​to .htaccess:

php_value mssql.textlimit 10000000

php_value mssql.textsize 10000000

I had the same problem and fixed it by increasing the value for mssql.textlimit and mssql.textsize to an arbitrary value.

0
source

Source: https://habr.com/ru/post/1381597/

More articles:


All Articles