Hi
I have a two servers:
1. MSATER
mySQL 3.23.47 under Windows 2000
character_set: koi8_ru
character_sets: latin1 big5 czech euc_kr gb2312 gbk sjis tis620 ujis
dec8 dos german1 hp8 koi8_ru latin2 swe7 usa7
cp1251 danish hebrew win1251 estonia hungarian
koi8_ukr win1251ukr greek win1250 croat cp1257
latin5
2. SLAVE
mySQL 3.23.47 under Free BSD
character_set: koi8_ru
character_sets: koi8_ru big5 cp1251 cp1257 croat czech danish dec8
dos estonia euc_kr gb2312 gbk german1 greek hebrew
hp8 hungarian koi8_ukr latin1 latin2 latin5 swe7
usa7 win1250 win1251 win1251ukr ujis sjis tis620
Sequence of queries on the master (in cp1251 encoding):
SET OPTION CHARACTER SET cp1251_koi8;
INSERT INTO words (word) VALUES ('�����������������');
At the master-server all normally translated from cp1251 to koi8 and
inserted in table. But at the slave-server I have not translated
results.
mysqlbinlog dump resilts
=====================================================================
# at 80379
#020128 16:18:14 server id 1 Intvar
SET INSERT_ID = 235344;
# at 80401
#020128 16:18:14 server id 1 Query thread_id=47 exec_time=0 error_code=0
SET TIMESTAMP=1012227494;
SET CHARACTER SET cp1251_koi8;
# at 80464
#020128 16:18:14 server id 1 Query thread_id=47 exec_time=0 error_code=0
SET TIMESTAMP=1012227494;
INSERT INTO words (word) VALUES ('�����������������');
=====================================================================
Testing queries
# QUERY AT MASTER (results in koi8)
mysql> SELECT * FROM `words` WHERE id=235344;
+--------+-------------------+
| id | word |
+--------+-------------------+
| 235344 | ����������������� |
+--------+-------------------+
1 row in set (0.00 sec)
# QUERY AT SLAVE (results in koi8)
mysql> SELECT * FROM `words` WHERE id=235344;
+--------+-------------------+
| id | word |
+--------+-------------------+
| 235344 | ����������������� |
+--------+-------------------+
1 row in set (0.00 sec)
Where is problem and what can I do for solve it?
Sorry for my Enlish
--
Lyubomir mailto:[EMAIL PROTECTED]
---------------------------------------------------------------------
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
