From: tomasz at biznespolska dot pl Operating system: windows 2000 Server PHP version: 4.3.6 PHP Bug Type: MSSQL related Bug description: changing some characters when communicating with MSSQL database under Apache1
Description: ------------ Configurations on which I've noted this bug: Windows 2000 Server, Apache1.3.29, PHP(tested versions: 4.3.3 and 4.3.6, both CGI and SAPI module), SQL Server 7.0 This bug is NOT present under Apache2 and IIS. Some of Polish characters are changed to completely different chars, while communicating with a MSSQL7. Example below is best description of problem. As a production server I use Apache2 + PHP, but because it is recommended to use Apache1 with PHP, so I've tried to downgrade, and then I've encountered this problem. Now I'm running Apache2 on port 80 and Apache1 on port 88, so this is link to script with bug: http://www.biznespolska.pl:88/test.php and same script through Apache2 (without the bug): http://www.biznespolska.pl/test.php My changes in php.ini: extension=php_mssql.dll mssql.datetimeconvert = Off mssql.textlimit = 100000 mssql.textsize = 100000 mssql.max_procs = 250 Reproduce code: --------------- // connection to database already established echo $sql = "SELECT '¿³'"; echo "<br />\n"; $re = mssql_fetch_row(mssql_query($sql)); echo $re[0]; Expected result: ---------------- SELECT '¿³' ¿³ Actual result: -------------- SELECT '¿³' ª- -- Edit bug report at http://bugs.php.net/?id=28105&edit=1 -- Try a CVS snapshot (php4): http://bugs.php.net/fix.php?id=28105&r=trysnapshot4 Try a CVS snapshot (php5): http://bugs.php.net/fix.php?id=28105&r=trysnapshot5 Fixed in CVS: http://bugs.php.net/fix.php?id=28105&r=fixedcvs Fixed in release: http://bugs.php.net/fix.php?id=28105&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=28105&r=needtrace Need Reproduce Script: http://bugs.php.net/fix.php?id=28105&r=needscript Try newer version: http://bugs.php.net/fix.php?id=28105&r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=28105&r=support Expected behavior: http://bugs.php.net/fix.php?id=28105&r=notwrong Not enough info: http://bugs.php.net/fix.php?id=28105&r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=28105&r=submittedtwice register_globals: http://bugs.php.net/fix.php?id=28105&r=globals PHP 3 support discontinued: http://bugs.php.net/fix.php?id=28105&r=php3 Daylight Savings: http://bugs.php.net/fix.php?id=28105&r=dst IIS Stability: http://bugs.php.net/fix.php?id=28105&r=isapi Install GNU Sed: http://bugs.php.net/fix.php?id=28105&r=gnused Floating point limitations: http://bugs.php.net/fix.php?id=28105&r=float