Hi,
I'm trying to migrate an old system to a newer - while doing that I
have to move the database. The old database i UTF-8
encoded, and the new one is Latin-1.
To move the data I'm doing something similar to:
INSERT INTO new_db.table (new_db.field) SELECT
CONVERT(old_db.field USING latin1)
First, check if actual data in your tables after this conversion is
really properly encoded. Launch your mysql command line client,
execute
SET NAMES latin1;
and do some selects on your table data to see if it's readable.
If it is, then all you need is to make PHP use latin1 when reading
data from
Also the good way of doing conversion itself is mysqldump table
structure, then import the dump, launch mysql command line utility (or
use phpmyadmin for that) and alter encoding on database and all needed
tables and columns, then mysqldump the first database using utf8
charset (without dropping