Hello.
Use
set NAMES 'utf8';
to set the connection character sets to the corresponding values. See:
http://dev.mysql.com/doc/mysql/en/charset-connection.html
Rob Cochrane <rob@stripped> wrote:
> Hi Gleb,
>
> Ok here is the command line info which also answers the version question.
> Enter password: **********
> Welcome to the MySQL monitor. Commands end with ; or \g.
> Your MySQL connection id is 1 to server version: 4.1.9-nt
>
> Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
>
> mysql> show variables like '%char%';
> +--------------------------+--------------------+
> | Variable_name | Value |
> +--------------------------+--------------------+
> | character_set_client | latin1 |
> | character_set_connection | latin1 |
> | character_set_database | utf8 |
> | character_set_results | latin1 |
> | character_set_server | utf8 |
> | character_set_system | utf8 |
> | character_sets_dir | C:\share\charsets/ |
> +--------------------------+--------------------+
> 7 rows in set (0.72 sec)
>
> mysql>
> I am downloading v.10 right now. I believed we were using .10 but in
> verifying I have found not. I will re-test when the upgrade is installed.
>
> Many thanks
>
> Rob
>
> Gleb Paharenko wrote:
>
>>
>> At first, we should check that there is nothing wrong with the
>> character_set_xxx variables. Please send us the output of the
>> following statement:
>>
>> show variables like '%char%';
>>
>> Does the problem remain if you are making the query using a mysql
>> command line client? Do you use the latest release (4.1.10 now)?
>>
>>
>>
>
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Gleb Paharenko
/ /|_/ / // /\ \/ /_/ / /__ Gleb.Paharenko@stripped
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET
<___/ www.mysql.com
