Reputation: 693
I have to store text written in the Russian language in mySQL table and also I have to pick up the Euro symbol from the mySQL table and present it to the user in the browser. I used the mysql_set_charset('utf8') and it successfully saves the text in Russian in the database, but then the Euro symbol does not appear. If I remove that statement then the Euro symbol appears but the Russian characters are stored incorrectly.
Upvotes: 0
Views: 795
Reputation: 516
If you mean the Euro is not posted on the Webpage. Maybe your html document is not set to UTF-8. UTF-8 lists the euro sign.
Upvotes: 0
Reputation: 15711
A table in "utf8_general_ci" can store Russian and Euro without any problems. http://www.collation-charts.org/mysql60/mysql604.utf8_general_ci.european.html
Upvotes: 1