Re: replication from 4.1 to 5.5 and character set change

[Gaspare Siclari]

Hi, and thanks for the quick reply.

As you said, blob type has no character, because it is a binary.

The problem is:
we need to convert an entire db from latin to utf8, but we can not made downtime.
We should be able to do all using the replica ...
I don't know if anyone made this type of changes ...

Our application are just tested on mysql 5.5, but the problem are the blob field.

Reading on some forums, someone suggest to change the blob field into a text, convert the text, and then come back to blob ... every change is done on a slave.
I mean:
5.0 ( iso - blob ) -> 5.1 ( iso - text ) -> 5.1 ( utf8 - text ) -> 5.1 ( utf8 - blob ) -> 5.5 ( utf8 - blob )

Ideally this complex replica should work... but the replica stop on the 2* replica ( 5.1 ( utf8 - text ) ) with the error: Incorrect string value: '\xE9*^"\xA3$ ....

I tried to change the bin-log format replication from statemnet to row, but in this case i receive the error: cannot be converted from type 'varchar(255)' to type 'varchar(255)', Error_code: 1677

I have no other idea ....

could someone help us in this particular activity?

Thanks

Gaspare