user1369905
user1369905

Reputation: 693

UTF-8: Russian characters and Euro symbol do not appear and store in mysql table

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

Answers (2)

Nicole Stutz
Nicole Stutz

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

Salketer
Salketer

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

Related Questions