how to insert multilanguage text to mysql database and view it again using php ?

im trying to insert multilanguage text into mysql database and

but the text appear as symbols in phpmyadmin and the same thing when i try to view the text in web browser

when the text is in a text file it appears normal but after insert the data to mysql it appears as symbols

 

For what purpose you are using the multilangauge text?

 

i am creating a bible website that contain many bible languages

i import the bible data from text files

 

So why are u bothering about mysql view while you display in the site its coming correctly na?

 

no i have the same problem in the site

 

refer this link http://www.eggheadcafe.com/communit...ta-in-table-and-try-to-retrieve-as-it-is.aspx

 

thank you learnerabn but my database charset is already unicode utf8 and the site page charset is utf-8

 

thanks for information...

 

You should use UTF-8 charset.
then has no problem.

 

If you have your storage as UTF8 and your special characters are being broken, make sure your client is connecting with UTF8. This could be an issue with PHP and not MySQL.