Hi,

I am working on a product that requires internationalisation. I maintain separate language files for each and every language and use UTF-8 encoding.

My HTML meta tags use UTF-8 format. For the database, I use
as my first query after connecting to the database.

While this works great for some characters (german), it doesn't for russian. Russian characters work fine only if I do not execute this query.

Could anyone please let me know the procedure to follow when one works on a project that will have multiple language data?

I have done the below till now.

1) HTML meta tags -> UTF8
2) Incoming and outgoing mails -> utf-8 encoded and decoded.
3) Mysql -> set character set=utf8

What else do I need to do?

Thank you in advance!

Well, I solved the problem. My database had latin1 character set and hence didn't work well with languages that needed more bytes.

To fix the problem, create database using utf8 encoding.