Re: [gentoo-user] php database character set

[Joseph]

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