Sticky Posts
Aug 26, 2009
Convert MySQL Database (Schema) / Table To UTF8 Charset
I haven't worked too much in my PHP experience with international (non-English) characters [I used to handle foreign scraping in C++ UNICODEian] and pretty much all I saved in databases was HTML Encoded. Finally decided UTF8 MySQL encoding is not a feature to ignore anymore and is a must have when using the 'funky characters'.
These are my functions I use to bulk convert databases / tables in mysql to UTF8 character encoding. Have fun with them.
Registration is quick, painless and worth its weight in gold.
*** Functions use el_sql_stubFunction.
Examples:
These are the tricky examples. Figure the rest out from the code.
- el_sql_utf8Schema('*'); // Converts all databases
- el_sql_utf8Schema('*.*'); // Converts all databases and child tables
- el_sql_utf8Table('*'); // Converts all tables in current schema
Use these functions wisely and look at the code. It's pretty much commented. It's a glance at how I code ... parameters ... possibilities.
PS: Thanks for the kind words.

