From: skissane at iips dot mq dot edu dot au
Operating system: Linux
PHP version: 4.3.7
PHP Bug Type: MSSQL related
Bug description: Strange SQL server error when query contains special chars
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 bug report at http://bugs.php.net/?id=28908&edit=1
--
Try a CVS snapshot (php4): http://bugs.php.net/fix.php?id=28908&r=trysnapshot4
Try a CVS snapshot (php5): http://bugs.php.net/fix.php?id=28908&r=trysnapshot5
Fixed in CVS: http://bugs.php.net/fix.php?id=28908&r=fixedcvs
Fixed in release: http://bugs.php.net/fix.php?id=28908&r=alreadyfixed
Need backtrace: http://bugs.php.net/fix.php?id=28908&r=needtrace
Need Reproduce Script: http://bugs.php.net/fix.php?id=28908&r=needscript
Try newer version: http://bugs.php.net/fix.php?id=28908&r=oldversion
Not developer issue: http://bugs.php.net/fix.php?id=28908&r=support
Expected behavior: http://bugs.php.net/fix.php?id=28908&r=notwrong
Not enough info: http://bugs.php.net/fix.php?id=28908&r=notenoughinfo
Submitted twice: http://bugs.php.net/fix.php?id=28908&r=submittedtwice
register_globals: http://bugs.php.net/fix.php?id=28908&r=globals
PHP 3 support discontinued: http://bugs.php.net/fix.php?id=28908&r=php3
Daylight Savings: http://bugs.php.net/fix.php?id=28908&r=dst
IIS Stability: http://bugs.php.net/fix.php?id=28908&r=isapi
Install GNU Sed: http://bugs.php.net/fix.php?id=28908&r=gnused
Floating point limitations: http://bugs.php.net/fix.php?id=28908&r=float
