On 05/25/14 23:00, Michael Orlitzky wrote:
On 05/25/2014 10:43 PM, Joseph wrote:
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.
Oh, lose the dollar sign. It's common to prepend a dollar sign to a name
to signify that it's a variable. It borrows from shell, perl, PHP, etc.
which all do something similar for variables. It's ugly and redundant
there, but email is actually one place where I think it makes sense.
Yes, it worked, and I get:
CREATE DATABASE `catalog_sys` /*!40100 DEFAULT CHARACTER SET utf8 */
so it looks OK I think.
--
Joseph
