| 1 |
On 05/25/2014 08:06 PM, Joseph wrote: |
| 2 |
> On 05/25/14 19:32, Michael Orlitzky wrote: |
| 3 |
>> |
| 4 |
>> Then, in mysql, run, |
| 5 |
>> |
| 6 |
>> show create database $your_database; |
| 7 |
>> |
| 8 |
>> This will show you the default character set, like, |
| 9 |
>> |
| 10 |
>> /*!40100 DEFAULT CHARACTER SET utf8 */ |
| 11 |
>> |
| 12 |
>> If it says utf8 and you've got those lines in my.cnf, you're in good |
| 13 |
>> shape, and your console test (at least) should work. Getting PHP to play |
| 14 |
>> along is another adventure, but take it one step at a time. |
| 15 |
> |
| 16 |
> In /etc/mysql/my.cnf |
| 17 |
> I have them as default |
| 18 |
> |
| 19 |
> [client] |
| 20 |
> default-character-set = utf8 |
| 21 |
> |
| 22 |
> [mysqld] |
| 23 |
> character-set-server = utf8 |
| 24 |
> |
| 25 |
|
| 26 |
What about the output of "show create database $your_database;"? |
| 27 |
Depending on how the database was created, it could still have another |
| 28 |
character set. |
Archives