How to convert a complete Database to Unicode (UTF-8), using Windows.
First, create a dump file (use Mysqldump or phpMyAdmin). Then, open the file in Notepad. Do NOT open in Wordpad or Word. Notepad can handle large files not too well, but if you take some time it works.
Then save the file directly after opening it to a new file, and select "Unicode" below the field for the filename.
Then, load the database back up to the server. Make sure you do not upload it as a binary file. Maybe Zip it before uploading. Reload the file into the database using:
mysql --user=root --password databasename file.txt
You will be prompted for the root password. The file will be read into the database "databasename".
Last Update: 2004-10-19 02:31:27
FAQ >
Programming
>
MySQL
