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

ID: 12508 Updated by: tsugiiwa@kcej.konami.com Reported By: php@work-smarter.co.uk Status: Open Bug Type: MSSQL related Operating System: Windows 2000 PHP Version: 4.0.6 New Comment: I think this could be duplicate of #10114 or caused by same problem. Actualy Gustav's work around make me free from the error, but the return value was not fetched correctly. NULL is the always result for all fields. And, this workaround could be Ok for ODBC function only. Not succeeded at mssql functions. Previous Comments: ------------------------------------------------------------------------ [2002-01-10 07:15:46] php@gustl.net 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 ------------------------------------------------------------------------ [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