Bug #13839 Updated: mysql_db_query does converts EURO symbol

From: Date: Fri, 26 Oct 2001 19:44:56 +0000
Subject: Bug #13839 Updated: mysql_db_query does converts EURO symbol
References: 1  Groups: php.dev 
Request: Send a blank email to php-dev+get-69089@lists.php.net to get a copy of this message 
ID: 13839
Updated by: sander
Reported By: Martin_Rauch@web.de
Old Status: Open
Status: Bogus
Bug Type: MySQL related
Operating System: Linux 2.2.18
PHP Version: 4.0.6
New Comment:

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.

Previous Comments:
------------------------------------------------------------------------

[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)

« previous php.dev (#69089) next »