Version: 1.00, by borbole
Developer Last Online: Oct 2015
Category: Administrative and Maintenance Tools -
Version: 4.1.11
Rating:
Released: 04-27-2012
Last Update: 04-28-2012
Installs: 26
DB Changes Uses Plugins
No support by the author.
This tool will convert the character collation of your database to utf-8.
After you install it, go to your Admin Panel->Maintenance->General Update Tools and all the way to the bottom there is a new option added called: UTF-8 Conversion.
Important: MAKE FIRST A BACKUP OF YOUR DATABASE BEFORE YOU RUN THIS TOOL!
If you will need support/assitence with it, please post at the mod 's thread at my forum.
I guess I was referring to running it in case there were a few table that weren't set as UTF-8, for whatever reason. Does this also set the default collation to UTF-8 for the whole db?
Yes, that will set the collation to utf-8 for the entire database.
Quote:
Originally Posted by Merjawy
I take it back
After checking the site again this morning.. I found few issues
1- Although all tables in db have been converted to UTF-8, the sum at the buttom still shows the total tables are still "latin"
2- Arabic language got totally messed up in Mobile styles
3- when I tried to upgrade to latest release 4.1.12PL1, it hung at 41%, had to rerun upgrade script to get it done.
4- Arabic language with all different settings became garbage (windows-1256 and UTF-8)
I even installed a UTF-8 Arabic file that I use on another site and it didn't display right.
That's my latest report.. I am going back to reload the backup and finish my upgrade.. Thanks anyway.. I will try to play with this again later after I am done with restoring my site and getting it back running.
Regards
Thank you for your report. I have tried this tool on several sites, small and medium ones, and I never encountered any issues during my tests. It converted the collation character as it was supposed to and the special characters worked properly.
About the upgrade hang up that you describe, I do not think it is related to my mod as it has nothing to do with that part.
But as long as a database backup is made beforehand then you are covered as you can easily revert back in case of any issues.
Actually this product is converting only the structure without the content
After complete try to enter the database from phpmyadmin and read the (post) table, still you cannot read the special characters, what this mod did is the same when you open the database and change the charset for all tables manually.
With that mod you will be able to convert the database to UTF-8 and you can read all the special characters from phpmyadmin which means both structure and content has been converted.
Actually this product is converting only the structure without the content
After complete try to enter the database from phpmyadmin and read the (post) table, still you cannot read the special characters, what this mod did is the same when you open the database and change the charset for all tables manually.
This is true, I was expecting more from this product. It did change the charsets, but content remains the same. Conversion was successful, no problems so far...
I test this on a test site, I was having problems with weird character sets within the forum. This hack has removed them ok, just one thing it has replace all the weird characters to a ? is there a way to fix this?
Wow, What an excellent job! Borbole sir! I am not going to use this now, but I def gave it a 5 Stars, because this will help may out with their forums! Thanks for your amazing work and contribution!
UTF-8 Coallition Conversion Details »»
About Developer
DB Changes 
No support by the author.
04-29-2012, 01:03 PM
