#28908 [Opn->Asn]: Strange SQL server error when query contains special chars

ID: 28908 Updated by: iliaa@php.net Reported By: skissane at iips dot mq dot edu dot au -Status: Open +Status: Assigned Bug Type: MSSQL related Operating System: Linux PHP Version: 4.3.7 -Assigned To: +Assigned To: fmk Previous Comments: ------------------------------------------------------------------------ [2004-06-24 08:50:10] skissane at iips dot mq dot edu dot au Also, I tested this, it works fine on 4.3.6. So this is a regression in 4.3.7. ------------------------------------------------------------------------ [2004-06-24 08:06:45] skissane at iips dot mq dot edu dot au Description: ------------ running freetds 0.63 ./configure: './configure' '--with-apxs2=/usr/sbin/apxs' '--with-mssql=/usr/local' '--with-mysql' '--with-curl' '--with-dom' '--with-zlib' '--enable-xslt' '--with-xslt-sablot' '--with-sablot-js' '--enable-dba' '--with-cdb' '--with-gd' '--with-socket' '--with-ldap' Reproduce code: --------------- <? $r = mssql_connect("<servername>","<username>","<password>"); mssql_query("SELECT '" . chr(183) . "'",$r); The above query works fine when run directly from Query Analyser. (where <servername> is a SQL Server 2000; freetds protocol version used 8.0.) Expected result: ---------------- No error. Actual result: -------------- Warning: mssql_query(): message: Unclosed quotation mark before the character string 'é¼ (severity 15) in /home/skissane/adm/freetds-0.63.dev.20040622/phptest.php on line 3 Warning: mssql_query(): message: Line 1: Incorrect syntax near 'é¼ (severity 15) in /home/skissane/adm/freetds-0.63.dev.20040622/phptest.php on line 3 Warning: mssql_query(): Query failed in /home/skissane/adm/freetds-0.63.dev.20040622/phptest.php on line 3 ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=28908&edit=1