Sql2005 migration utf8mb4 problem
Posted by:
gan li
Date: July 01, 2013 01:39AM
I really need help for Sql2005 migration problem.
MY GOAL:
To migrate many Sql2005 DataBases with data to a MySQL version 5.6 using Workbench.
Sql2005 DataBases COLLATE is Chinese_PRC_CI_AS.
MySQL Workbench Version 6.0.2 beta.
The Sql2005 DataBases contain some 4 bytes UTF-8.
When Mysql use utf8 collate, Get Error: during charset conversion of wstring: No error.
So i select mysql collate utf8mb4.
+--------------------------+--------------------+
| Variable_name | Value |
+--------------------------+--------------------+
| character_set_client | utf8mb4 |
| character_set_connection | utf8mb4 |
| character_set_database | utf8mb4 |
| character_set_filesystem | binary |
| character_set_results | utf8mb4 |
| character_set_server | utf8mb4 |
| character_set_system | utf8 |
| collation_connection | utf8mb4_general_ci |
| collation_database | utf8mb4_general_ci |
| collation_server | utf8mb4_general_ci |
+--------------------------+--------------------+
modify ther db_mssql_migration_grt.py
def migrateCharsetCollation(self, state, charset, collation, source_object, target_object):
if collation:
state.addMigrationLogEntry(0, source_object, target_object,
'Collation %s migrated to utf8_general_ci' % (collation))
return '', 'utf8_general_ci'
return charset, collation
as:
def migrateCharsetCollation(self, state, charset, collation, source_object, target_object):
if collation:
state.addMigrationLogEntry(0, source_object, target_object,
'Collation %s migrated to utf8mb4_general_ci' % (collation))
return '', 'utf8mb4_general_ci'
return charset, collation
When migrate also get Error: during charset conversion of wstring: No error.
How to migrate Sql2005 DataBases which have some 4 bytes UTF-8 to a MySQL?
Thanks and regards.