Japanese and Russian Text Encoding Problem

[sandeepindia]

I m using PHP Version 4.3.2 & Mysql version 3.23.58(No collation etc).
My site is in shift JIS encoding. I've both japanese users & russian users. They have entered their member profile in their language. So I have over 5000 member data both in russian & japanese. Now my russian member profile page is showing junk characters. if I change the encoding to cyrillic(window-1251) then russian character are ok, but japanese characters get junked. I can not use both encoding to same page and if I use UTF-8 encoding the old data(both language) is get junked.

Pls Pls help if you know the solution.

Thanks in advance.

Sandeep

[pbmods]

Heya, Sandeep.

I encountered a similar problem on a couple of sites that I worked on. Here's how I solved it:

http://blog.pbmods.com/2008/07/01/failing-gracefully-with-utf-8-part-2/