Mysql Encoding Change

[sandeepindia]

Hi all,

I m using PHP Version 4.3.2 & Mysql version 3.23.58 (No collation etc).
My site is in shift JIS encoding and all the data is in shift JIS.
Now I want to convert it to UTF-8 encoding. so that all the old data readable in UTF-8 encoding. Is it possible.

Pls help me cause its very important.

Thanks in advance.

With Regards
Sandeep

[pbmods]

Heya, Sandeep.

Use MySQL's CONVERT function to accomplish this (http://dev.mysql.com/doc/refman/5.0/...t-convert.html).