Error during charset conversion of wstring
Hi I am getting following error while migrating data from SQL server 2012 to MySQl56 I have even tried with UTF8 character set but still persisting with the same error any help in this regards is highly appreciated
04:01:22 [INF][ copytable]: Opening ODBC connection to [unknown] 'DSN=DEV;DATABASE=;UID=***;TDS_VERSION=7.2;PWD=XXX'
04:01:22 [INF][ copytable]: ODBC connection to 'DSN=DEV;DATABASE=;UID=***;TDS_VERSION=7.2;PWD=' opened
8 total rows in 1 tables need to be copied:
- [X].[dbo].[ct_author]: 8
Determine number of rows to copy finished
Copy data to target RDBMS....
Migrating data...
wbcopytables.exe --odbc-source="DSN=DEV;DATABASE=;UID=***;TDS_VERSION=7.2" --target="root@localhost:3306" --progress --passwords-from-stdin --thread-count=1 --source-rdbms-type=Mssql --table-file=c:\users\ ~1.des\appdata\local\temp\2\tmpo_bfxm
Loading table information from file c:\users\ ~1.des\appdata\local\temp\2\tmpo_bfxm
`X`.`ct_author`:Copying 8 columns of 8 rows from table [X].[dbo].[ct_author]
ERROR: `X`.`ct_author`:Error during charset conversion of wstring: No error
ERROR: `X`.`ct_author`:Failed copying 8 rows
FINISHED
--table [X] [dbo].[ct_author] `X` `ct_author` [id] `id` [id], [author_name], [author_designation], [author_profile], [author_picture], [author_status], CAST([author_link] as NVARCHAR(255)) as [author_link], [weight]
04:01:22 [INF][ copytable]: Connecting to MySQL server at localhost:3306 with user root
04:01:22 [INF][ copytable]: Connection to MySQL opened
04:01:22 [INF][ copytable]: Opening ODBC connection to [Mssql] 'DSN=DEV;DATABASE=;UID=tdgdba;TDS_VERSION=7.2;PWD=XXX'
04:01:22 [INF][ copytable]: ODBC connection to 'DSN=DEV;DATABASE=;UID=tdgdba;TDS_VERSION=7.2;PWD=' opened
04:01:22 [INF][ copytable]: Connecting to MySQL server at localhost:3306 with user root
04:01:22 [INF][ copytable]: Connection to MySQL opened
04:01:22 [WRN][ copytable]: 1324 characters could not be converted to UTF-8 during copy
04:01:23 [INF][ copytable]: Re-enabling triggers for schema 'X'
04:01:23 [INF][ copytable]: No triggers found for 'X'
Copy helper has finished
Data copy results:
- `X`.`ct_author` has FAILED (0 of 8 rows copied)
Subject
Views
Written By
Posted
Error during charset conversion of wstring
3432
June 02, 2016 03:20AM
1260
June 20, 2016 07:34AM
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.