Re: Replication, charset / collations Problem

2005-08-10 Thread Gleb Paharenko
Hello. > `key` varchar(255) character set utf8 collate utf8_bin NOT NULL All your character_set_xxx variables have a 'latin1' value, while the `key` column has utf8. In my opinion, this is the root of the problem. Marco P$hler <[EMAIL PROTECTED]> wrote: >> Please, send the output o

Re: Replication, charset / collations Problem

2005-08-09 Thread Marco Pöhler
> Please, send the output of the following statement executed both on > master and slave: > > show variables like '%char%'; mysql> show global variables like 'c%'; +--++ | Variable_name| Value | +-

Re: Replication, charset / collations Problem

2005-08-09 Thread Gleb Paharenko
Hello. Please, send the output of the following statement executed both on master and slave: show variables like '%char%'; Send the definition of your table as well: SHOW CREATE TABLE sum_day_key_requests; Marco P$hler <[EMAIL PROTECTED]> wrote: > Hi, > > I try to repl

Re: Replication, charset / collations Problem

2005-08-09 Thread Marco Pöhler
Am Dienstag, den 09.08.2005, 17:57 +0400 schrieb Alexey Polyakov: > If charsets/collations are not set explicitly in my.cnf, server could > be using ones specified during compilation. > To check charsets and collations on the running server do: > show global variables like 'c%'; Thanks. I execute

Re: Replication, charset / collations Problem

2005-08-09 Thread Alexey Polyakov
> The only idea, which came into my mind, is that the server use different > default charsets or collations. I checked the configurations and can't > find a difference. Is there a possibility to check the default charsets > and collations on the running server ? If charsets/collations are not set