Re: replication from 4.1 to 5.5 and character set change
Posted by:
Rick James
Date: February 17, 2012 10:15PM
For the tables with latin1 in BLOB fields, please provide
SHOW CREATE TABLE -- need more detail
SHOW TABLE STATUS -- need to see the sizes
If the table is small enough, then something like this on the existing machine may get things started:
ALTER TABLE foo
MODIFY blob_field TEXT CHARACTER SET latin1
I'm still concerned that there is nothing in replication to trigger a charset conversion. And the error message you got implies that it is smart enough to complain instead.
Subject
Views
Written By
Posted
4679
February 10, 2012 09:42AM
2256
February 11, 2012 01:40PM
3594
February 14, 2012 10:26AM
Re: replication from 4.1 to 5.5 and character set change
2395
February 17, 2012 10:15PM
Sorry, you can't reply to this topic. It has been closed.
This forum is currently read only. You can not log in or make any changes. This is a temporary situation.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.