需要帮助开发一个2种语言的英语和法语网站

Question

In admin side he enters the english text and same will be converted into french (using google API) for example in admin side if i enter the text 'Category' the same converted into 'catégorie'(in IE--->cat�rie) and also save into database as

nameEnglish---> category
nameFrench --->catégorie

since the process is fine but my problem is in user side, if the user selects french language the content has to display in french. but it is displaying as 'catégorie' instead of what i was stored in DB 'catégorie'. I dont know what to do. Should i install any language pack? or is it db issue?

http://gates.cc/works/jp-evolution/blog-detail.php?lang=2&bId=7

Answer 1

Try storing special characters such as é and ü as HTML entities.

Check the PHP function htmlentities for converting special characters into HTML entities.

When you convert, f.e. "école" will be stored as: école and HTML will render the special characters correctly.

Edit: Based on my previous experiences, even when my collation was set to UTF-8, I had the same problem and had to convert them using HTML entities. So instead, I stored them as HTML entities from the beginning.