>Description:
Using "set character set cp1251_koi8" before updates insert right
data on master server (cp1251 from client recode to koi8 on server),
but replication on slave server wrong (data dosn't recode from
cp1251 to koi8).
>How-To-Repeat:
Setup replication with master and slave servers
Do with Master server:
set character set cp1251_koi8;
insert into test (test) values ('[text at cp1251 codepage]');
select test from test;
You will see text, recoded from cp1251 to koi8
Do with Slave server:
select test from test;
You will see text, *dosn't* recoded
>Fix:
Binary log on master (I see it with mysqlbinlog) is right:
query "set character set cp1251_koi8" is present. So, problem
with *slave* only.
>Submitter-Id: <submitter ID>
>Originator: Pavel Andreew
>Organization: Ekaterinburg Telegraph
>MySQL support: none
>Synopsis: "set character set cp1251_koi8" don't work on slave server
>Severity: serious
>Priority: low
>Category: mysql
>Class: sw-bug
>Release: mysql-3.23.47 (Source distribution)
>Server: /usr/bin/mysqladmin Ver 8.23 Distrib 3.23.47, for pc-linux-gnu on i686
Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL license
Server version 3.23.47-log
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /var/run/mysqld/mysqld.sock
Uptime: 4 hours 14 min 6 sec
Threads: 2 Questions: 178 Slow queries: 0 Opens: 12 Flush tables: 1 Open tables:
6 Queries per second avg: 0.012
>Environment:
System: Linux collage 2.4.17 #1 Tue Dec 25 12:39:34 YEKT 2001 i686 unknown
Architecture: i686
Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gcc /usr/bin/cc
GCC: Reading specs from /usr/lib/gcc-lib/i386-linux/2.95.4/specs
gcc version 2.95.4 (Debian prerelease)
Compilation info: CC='gcc' CFLAGS='' CXX='c++' CXXFLAGS='' LDFLAGS=''
LIBC:
lrwxrwxrwx 1 root root 13 ��� 6 10:31 /lib/libc.so.6 -> libc-2.2.4.so
-rwxr-xr-x 1 root root 1171196 ��� 3 23:07 /lib/libc-2.2.4.so
-rw-r--r-- 1 root root 2669312 ��� 3 23:07 /usr/lib/libc.a
-rw-r--r-- 1 root root 178 ��� 3 23:07 /usr/lib/libc.so
Configure command: ./configure --prefix=/usr --exec-prefix=/usr
--libexecdir=/usr/sbin --datadir=/usr/share --sysconfdir=/etc/mysql
--localstatedir=/var/lib/mysql --includedir=/usr/include --infodir=/usr/share/info
--mandir=/usr/share/man --enable-shared --with-libwrap --enable-assembler
--with-berkeley-db --with-innodb --enable-static --enable-shared --with-raid
--enable-thread-safe-client --without-readline
--with-unix-socket-path=/var/run/mysqld/mysqld.sock --with-mysqld-user=mysql
--without-bench --with-client-ldflags=-lstdc++ --with-extra-charsets=all
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
