#28105 [Asn->Bgs]: changing some characters when communicating with MSSQL database under Apache1

ID: 28105 Updated by: fmk@php.net Reported By: tomasz at biznespolska dot pl -Status: Assigned +Status: Bogus Bug Type: MSSQL related Operating System: windows 2000 Server PHP Version: 4.3.6 Assigned To: fmk New Comment: This is not a bug in PHP, but a feature in the DB Library from Microsoft. The DB library uses OEM to ANSI convertions depending on the context the library is used in (CLI,CGI,SAPI). You can control how values are returned from the 'Client Network Utility' Previous Comments: ------------------------------------------------------------------------ [2004-04-22 12:26:42] tomasz at biznespolska dot pl 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 this bug report at http://bugs.php.net/?id=28105&edit=1