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.