I'm trying to get UTF-8 working in my PHP app. It's all good now except for one thing.
During the installation process, I use the AdoDB XML Schema class to automatically create the necessary tables from XML files. This is great, but has the drawback that I don't get to specify the Character Set of the new tables, as AdoDb doesn't support that yet. What I'm looking for is the best way to get the desired result: all tables using the UTF-8 charset.
From what I can understand of the MySQL manual, I can set the default charset of the database, then create the tables and they will inherit the charset. However, as my app may not be the only one using this particular database, it's important that I restore the default charset after I've finished the installation.
Does this sound like the right way to go? Basically, I run:
Code: Select all
SHOW VARIABLES LIKE 'character_set_database'Any comments, or improvements?
TIA