On 05/25/2014 08:06 PM, Joseph wrote: > On 05/25/14 19:32, Michael Orlitzky wrote: >> >> Then, in mysql, run, >> >> show create database $your_database; >> >> This will show you the default character set, like, >> >> /*!40100 DEFAULT CHARACTER SET utf8 */ >> >> If it says utf8 and you've got those lines in my.cnf, you're in good >> shape, and your console test (at least) should work. Getting PHP to play >> along is another adventure, but take it one step at a time. > > In /etc/mysql/my.cnf > I have them as default > > [client] > default-character-set = utf8 > > [mysqld] > character-set-server = utf8 >
What about the output of "show create database $your_database;"? Depending on how the database was created, it could still have another character set.
