1 |
On 05/25/14 23:00, Michael Orlitzky wrote: |
2 |
>On 05/25/2014 10:43 PM, Joseph wrote: |
3 |
>>> |
4 |
>>> What about the output of "show create database $your_database;"? |
5 |
>>> Depending on how the database was created, it could still have another |
6 |
>>> character set. |
7 |
>> |
8 |
>> I was trying to run this command in phpmyadmin: |
9 |
>> show create database $temp; |
10 |
>> |
11 |
>> I'm getting an error message. |
12 |
>> |
13 |
> |
14 |
>Oh, lose the dollar sign. It's common to prepend a dollar sign to a name |
15 |
>to signify that it's a variable. It borrows from shell, perl, PHP, etc. |
16 |
>which all do something similar for variables. It's ugly and redundant |
17 |
>there, but email is actually one place where I think it makes sense. |
18 |
|
19 |
Yes, it worked, and I get: |
20 |
CREATE DATABASE `catalog_sys` /*!40100 DEFAULT CHARACTER SET utf8 */ |
21 |
|
22 |
so it looks OK I think. |
23 |
|
24 |
-- |
25 |
Joseph |