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