ID: 13839 Updated by: jeroen Reported By: [EMAIL PROTECTED] Status: Bogus Bug Type: MySQL related Operating System: Linux 2.2.18 PHP Version: 4.0.6 New Comment:
CHeck the contents of your database with the mysql command line tool. If it really says &, post your session here. Mysql> SELECT headline FROM article; ... Mysql> Previous Comments: ------------------------------------------------------------------------ [2001-10-29 07:30:19] [EMAIL PROTECTED] 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: "&#8364;" -> 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 ------------------------------------------------------------------------ [2001-10-26 15:44:55] [EMAIL PROTECTED] 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] [EMAIL PROTECTED] 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 &#8364; 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 -- PHP Development Mailing List <http://www.php.net/> To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
