insert euro symbol

[petroz]

Hi Guys,

 

I am having problem inserting a euro symbol into mysql.

 

<? 
/*

test sending currency symbols to server

*/

include 'db.php';

$symbol = $_GET['s'];

$query = mysql_query("INSERT INTO `events` (`currency`) VALUES ('$symbol')");

echo "INSERT INTO `events` (`currency`) VALUES ('$symbol')";

?>

 

The echo prints as expected; (note.. I am actually using the symbol in the query.. This forum parses it to a utf string.)

INSERT INTO `events` (`currency) VALUES ('€')

 

But when I look at what was inserted into the database, I am getting;

â

 

I've tried passing the value to GET encoded and decoded and I get the same result each time.

 

The strangest part is.. when I copy and paste that query into phpmyadmin... it shows up perfect.

 

[Mchl]

Did you set up connection encoding to utf8 ?

[petroz]

Hi Mchi,

 

Thanks for the reply. I am not sure what you mean by connection... but the whole database is set to utf8-unicode-1, so is the script.

 

Is there something I am missing?

 

Thanks,

Peter

[Mchl]

I assume you're setting up a connection in db.php file.

Check if there's

mysql_query('SET NAMES "utf8"');

after mysql_connect(...)

[petroz]

That did the job! Thanks a bunch!

 

Is this something smart to use on all my databases connectors?

 

Thanks Again!

[Mchl]

If you want to use utf8, you have to make sure you use it everywhere. This includes database connection.