Bug #12508 Updated: can't return a ntext type field in a select statement

ID: 12508 Comment by: php@gustl.net Old Reported By: php@work-smarter.co.uk Reported By: php@gustl.net Status: Open Bug Type: MSSQL related Operating System: Windows 2000 PHP Version: 4.0.6 New Comment: I found a good work around. Insert following SQL query after connecting to the MSSQL database: SET TEXTSIZE 100000 or to your estimated max size, which should be the same as defined in odbc_longreadlen (), if MSSQL is accessed through ODBC, which I prefer, because the PHP mssql functions don't return my german umlaute correctly. hope this helps gustav graf Previous Comments: ------------------------------------------------------------------------ [2001-08-01 04:44:03] php@work-smarter.co.uk selecting a ntext type field using mssql_query produces the following error message MS SQL message: ntext data cannot be sent to clients using DB-Library (such as ISQL) or ODBC version 3.7 or earlier. (severity 16) ------------------------------------------------------------------------ Edit this bug report at http://bugs.php.net/?id=12508&edit=1