I've received a server error running a Data transfer component from Sql Server to MySql db. The error message reads as follows:
[MySql][ODBC 5.1 Driver][mysqld-5.0.67-community-nt-log]Server does not support 4-byte encoded UTF8 characters.
The source Sql Server table contains nvarchar columns, the target MySql table contains varchar columns.
Can anybody shed some light on this problem?
It looks like a known bug. Here is the issue on MySQL bugs.
http://bugs.mysql.com/bug.php?id=67428