On 05/25/14 21:04, Michael Orlitzky wrote:
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.
I was trying to run this command in phpmyadmin:
show create database $temp;
I'm getting an error message.
--
Joseph
