note 64449 deleted from function.odbc-longreadlen by bjori
| From: | bjori@php.net | Date: | Sat, 15 Apr 2006 01:45:33 +0000 |
| Subject: | note 64449 deleted from function.odbc-longreadlen by bjori | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-108127@lists.php.net to get a copy of this message | ||
Note Submitter:
Reason: bad code
----
If you are having problems with truncated text fields in mssql queries (at 4096 characters), try the
following:
in php.ini:
- odbc.defaultlrl = 65536
- mssql.textlimit = 65536
- mssql.textsize = 65536
in your php code, before your queries:
- mssql_query ( 'SET TEXTSIZE 65536' , $myConn );
- ini_set ( 'mssql.textlimit' , '65536' );
- ini_set ( 'mssql.textsize' , '65536' );