Connecting Tech Pros Worldwide Forums | Help | Site Map

Mysql Encoding Change

Newbie
 
Join Date: Oct 2008
Posts: 2
#1: Nov 5 '08
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's Avatar
Site Moderator
 
Join Date: Apr 2007
Location: Texas
Posts: 5,435
#2: Nov 16 '08

re: Mysql Encoding Change


Heya, Sandeep.

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