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
4783
February 10, 2012 09:42AM
2295
February 11, 2012 01:40PM
3647
February 14, 2012 10:26AM
Re: replication from 4.1 to 5.5 and character set change
2446
February 17, 2012 10:15PM
Sorry, you can't reply to this topic. It has been closed.
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.