Location: PHPKode > scripts > MySQL Charset correction tool > mysql-charset-correction-tool-v1-0/README.txt
MySQL Charset correction tool v1.0

Global Internet d.o.o. - www.global.net.ba
Programming by Mario Mijic
===============================================

CONTENT

1. Introduction
2. Usage
3. License


===============================================
1. Introduction
===============================================

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.

===============================================
1. usage
===============================================

Point your browser to convert.php script, i.e. http://www.yourdomain.com/convert.php
Fill all html form fields (host, port, database, username and password), and chose desired charset to convert to.
Click on a "Start" button to start conversion.


===============================================
3. License
===============================================

This tool is free to use for personal and commercial use until all copyright and comment
lines remains intact in convert.php script file.
Return current item: MySQL Charset correction tool