[borbole]

Originally Posted by Boofo

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.

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.