ID: 24225
User updated by: lim at liones dot nl
Reported By: lim at liones dot nl
Status: Bogus
Bug Type: MSSQL related
Operating System: Win2000
PHP Version: 4.3.2
New Comment:
Thanks. You are right.
Previous Comments:
------------------------------------------------------------------------
[2003-06-17 10:47:37] [EMAIL PROTECTED]
The MSSQL Server client tools are "smart" and try to detect the code
page the client is using. If the server is accessed from the command
line you will get different results from the same query used as CGI
under IIS or another web server. If you are getting different results
from CGI and FastCGI, I would say it's a problem with FastCGI.
You can try to change the setting of 'Automatic ANSI to OEM convertion'
under DB-Library options in the Client Network Utility application. You
should change this parameter on the client computer!
------------------------------------------------------------------------
[2003-06-17 09:40:47] lim at liones dot nl
Description:
------------
In combination with fastcgi mssql_fetch_array and mssql_fetch_row gives
all characters ÿ ( chr(255) ) as ~ ( chr(152). This happens only when
fastcgi is turned on.
These characters are stored in a MS SQL Server 2000 database in a
varchar field.
Reproduce code:
---------------
First store a ÿ character in a varchar field in MS SQL Server 2000
mssql_connect( 'sqlserver,'username', 'password');
$result = mssql_query( "SELECT TOP 1 * FROM yourtable" );
print_r( mssql_fetch_array( $result ) );
Expected result:
----------------
correct result:
[0] => ÿ
Actual result:
--------------
returned result:
[0] => ~
------------------------------------------------------------------------
--
Edit this bug report at http://bugs.php.net/?id=24225&edit=1
