Bug #13839 Updated: mysql_db_query does converts EURO symbol

ID: 13839 User updated by: Martin_Rauch@web.de Reported By: Martin_Rauch@web.de Status: Bogus Bug Type: MySQL related Operating System: Linux 2.2.18 PHP Version: 4.0.6 New Comment: It is not the problem of the character set. It is a matter of changing the data before it gets inserted into the database. example: the orginal string is "€" the string that gets inserted by mysql_db_query is: "€" -> the character "&" gets encoded into "&"! Only the orginal string "€" displays an EURO character with the browser if you read it from the database with php and display it in a HTML page. Is there a way to tell mysql_db_query() not to touch the string before inserting it into the database?? Thanks Martin Previous Comments: ------------------------------------------------------------------------ [2001-10-26 15:44:55] sander@php.net mysql uses a different character-set than your browser does. Therefor, it prints character 128 (the euro-sign) different than most text-processors. It is actually stored correctly, if you retrieve it (with i.e. PHP) and display it in your browser, it still is a euro-sign. ------------------------------------------------------------------------ [2001-10-26 11:15:08] Martin_Rauch@web.de Try this $headline = "This is a € prize"; mysql_db_query( $db, "insert into article set headline='$headline'"); this would insert the string "This is a € prize"! obviously the command mysql_db_query does a converting on the input string. But in this case the result would be a false string. Any help? Martin ------------------------------------------------------------------------ Edit this bug report at http://bugs.php.net/?id=13839&edit=1