Re: 4.1.7 Character set problem ( Ithink?)

2005-02-17 Thread Gleb Paharenko
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 Paharenk

Re: 4.1.7 Character set problem ( Ithink?)

2005-02-14 Thread Ian Gibbons
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

Re: 4.1.7 Character set problem ( Ithink?)

2005-02-14 Thread Gleb Paharenko
Hello. Please tell us, what output the following statement produces: SHOW VARIABLES LIKE '%char%'; You can use hexademical values for inserting the data. See: http://dev.mysql.com/doc/mysql/en/hexadecimal-values.html "Ian Gibbons" <[EMAIL PROTECTED]> wrote: > Hi List, > > I a

4.1.7 Character set problem ( Ithink?)

2005-02-11 Thread Ian Gibbons
Hi List, I am having a strange problem on Linux Fedora Core 3 with MySQL 4.1.7 ( offical mysql rpms). The data was originally stored in MySQL 3.something and was placed into the database via a MySQLDump file. It is too late to reload the data. I have a table called fees: CREATE TABLE `fees` (