MySQL Charset correction tool 1.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.
More popular Database Tool
- 1.8 KB
- 09/05/2009 07:41:54
- 15.6 KB
- 09/05/2009 07:09:44