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

Reply via email to