From: Ian Gibbons (mysql2fishnet.co.uk)
Date: Mon Feb 14 2005 - 05:36:07 CST

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

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
--

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

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