I have a site where I will need to display some Chinese language pages. If I copy and paste the text and save the page it is all converted to Question marks "????????".
I have done some searches and it seems this is due to my database being encoded in something other than utf8_general_ci.
Q1 - is there an automated way to change the encoding of all the existing tables etc? Going through the database in PHP myadmin and manually changing all the encodings would be a nightmare.
Q2 - On a new installation is there a way to force the encoding to utf8_general_ci?