From: Gleb Paharenko (gleb.paharenkoensita.net)
Date: Mon Feb 14 2005 - 09:19:30 CST

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

Hello.

The value of the character_set_system in this
case doesn't have affect in this case. You table
has latin2 as default character set, and all
your character_set_xxx variables have a latin1 value.

"Ian Gibbons" <mysql2fishnet.co.uk> wrote:
> On 12 Feb 2005 at 14:09, Gleb Paharenko wrote:
>
>> Hello.
>>
>> Please tell us, what output the following statement produces:
>> SHOW VARIABLES LIKE '%char%';
>
> Hi Gleb,
>
> mysql> SHOW VARIABLES LIKE '%char%';
> +--------------------------+----------------------------+
> | Variable_name | Value |
> +--------------------------+----------------------------+
> | character_set_client | latin1 |
> | character_set_connection | latin1 |
> | character_set_database | latin1 |
> | character_set_results | latin1 |
> | character_set_server | latin1 |
> | character_set_system | utf8 |
> | character_sets_dir | /usr/share/mysql/charsets/ |
> +--------------------------+----------------------------+
> 7 rows in set (0.08 sec)
>
> I assume the character_set_system being utf8 is the problem, but how do I change
> it?
>
>> You can use hexademical values for inserting the data. See:
>> http://dev.mysql.com/doc/mysql/en/hexadecimal-values.html
>
> I've taken a look at this and it could prove very useful. I wish I had the time to read
> the whole manual!
>
> Thanks
>
> Ian

--
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.Paharenkoensita.net
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET
       <___/ www.mysql.com

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]