PHP Script Codes > MySQL Charset correction tool v1.0
MySQL charset correction tool is excellent tool for converting charsets in MySQL databases
without changing columns values.
It can be used after MySQL upgrade or after restoring missing databases to repair or
to convert charset.
This problem is often seen when doing restore of Joomla database to a newer MySQL version.
This tool doesn't require any manual conversions or any PHP & MySQL knowledge.
All it does is scan your database for tables, and then scans those tables for columns of types
TINYTEXT, TEXT, MEDIUMTEXT and LONG TEXT.
All those columns are then converted to BLOB types, i.e. TINYTEXT is converted to TINYBLOB.
After that those BLOB types are returned to TEXT types but this time with desired charset
so no data is converted or affected in any way.
Doing this manually can be very long and painful work, but with this script it's a matter
of seconds.
Hope you'll find this script very useful.