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" <[EMAIL PROTECTED]> 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 / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
