Bug #13839 Updated: mysql_db_query does converts EURO symbol
ID: 13839
Updated by: jeroen
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:
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] Martin_Rauch@web.de
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
------------------------------------------------------------------------
[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
Thread (5 messages)