#37879 [Opn->Asn]: Wrong Character Encoding, Loses Characters
| From: | iliaa@php.net | Date: | Sun, 07 Jan 2007 18:23:10 +0000 |
| Subject: | #37879 [Opn->Asn]: Wrong Character Encoding, Loses Characters | ||
| References: | 1 | Groups: | php.bugs |
| Request: | Send a blank email to php-bugs+get-107282@lists.php.net to get a copy of this message | ||
ID: 37879
Updated by: iliaa@php.net
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