Hi all This is my first post here. I am developing a multilanguage app (forum) in PHP mySQL. My db encoding is utf8_unicode_ci Default language is english and page encoding is utf-8 If i add support for a new language in utf-8 encoding itself , i have no problems. But if I add a new language in another encoding, and say user chooses that language and posts his thread in the selected language. Now the data will be read from the page in the corresponding encoding , but the in the back end my db is utf8. will there be any issue? what is the best practice i should follow? Hope you can help me out. Thanks RP
I don't think it is possible for Mysql database to have two encoding in the same time,But Utf-8 can cover many languages, So it is OK to have many languages that share the same encoding .. Here is Some info from Mysql.com
If you will read on net Localization with multilanguage support in the web site, you will be helped. You may go for a PHP framework like codeigniter to address this issue.