ID: 37879
Updated by: [EMAIL PROTECTED]
Reported By: captainqwark at gmail dot com
-Status: Open
+Status: Assigned
Bug Type: MSSQL related
Operating System: Windows XP
PHP Version: 5.1.4
-Assigned To:
+Assigned To: fmk
Previous Comments:
------------------------------------------------------------------------
[2006-06-21 22:31:21] captainqwark at gmail dot com
Description:
------------
Retrieving data from a mssql database using ISO-8859-1 internaly
returns wrong characters for french characters.
Reproduce code:
---------------
$mssql = mssql_connect("-","-","-");
if(!$mssql){
echo "connect failed\r\n";
} else {
echo "connect successful\r\n";
}
mssql_select_db("contacts",$mssql);
$selectSQL = "SELECT first_name FROM contacts ORDER BY username";
$result = mssql_query($selectSQL, $mssql);
while ($row = mssql_fetch_array($result)) {
echo $row['first_name'];
}
Expected result:
----------------
Josée
Actual result:
--------------
Jos
------------------------------------------------------------------------
--
Edit this bug report at http://bugs.php.net/?id=37879&edit=1