locked
Data migration from MYSQL to SQLSERVER RRS feed

  • Question

  • Hi everyone,

    When trying to migrate data from MYSQL to SQLSERVER via SSIS. Foreign characters comes as ????.

    In MYSQL Column is varchar CHARACTER SET utf8 COLLATE utf8_unicode_ci and in SQL Server its NVARCHAR.

    Tried changing the code page in ODBC Connection Manager still getting ?????.

    Tried enabling data viewer and see the data even there its ???? instead of arabic and chinese 

    Thanks,

    Deepak


    Friday, August 10, 2018 4:14 AM

Answers

All replies

  • So before the data arrive to SQL Server you see ???  in data viewer , that makes me think that the problem is in the driver you connect to MySQL

    What connector you are using?

    https://blogs.msdn.microsoft.com/mattm/2008/03/04/connecting-to-mysql-from-ssis/

    Also

    https://www.mssqltips.com/sqlservertip/3119/import-utf8-unicode-special-characters-with-sql-server-integration-services/


    Best Regards,Uri Dimant SQL Server MVP, http://sqlblog.com/blogs/uri_dimant/

    MS SQL optimization: MS SQL Development and Optimization
    MS SQL Consulting: Large scale of database and data cleansing
    Remote DBA Services: Improves MS SQL Database Performance
    SQL Server Integration Services: Business Intelligence

    • Proposed as answer by Pirlo Zhang Friday, August 10, 2018 7:34 AM
    • Marked as answer by deepz84 Monday, October 8, 2018 4:28 AM
    Friday, August 10, 2018 5:05 AM
  • Hi Uri

    You are right there are two drivers one for ANSI and one for Unicode. I have used ANSI.Will change that and update you,

    MANY THANKS

    Friday, August 10, 2018 5:43 AM
  • Hi deepz84,

    Is there any updates here?

    If you have resolved this issue, please mark appropriate reply as answer.

    Thanks,

    Pirlo Zhang  


    MSDN Community Support<br/> Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact <a href="mailto:MSDNFSF@microsoft.com">MSDNFSF@microsoft.com</a>.

    Tuesday, August 14, 2018 9:40 AM