Oracle toSQL2008 (Problem with convertation UTF-8 data)


  • Hi,

    Is SSMA supports in any way convertation UTF-8 strings to SQLServer corresponding data?

    I tried diffrent combinations with nvarchar target type, custom migration sql with Oracle's conver(column, charset_from, charset_to)..

    And have not acceptable results from Oracle error (ORA-29275: partial multibyte character) to unreadable values in target table. 

    1. března 2012 10:44


  • Hi Omg-cmd,

    >> ORA-29275: partial multibyte character) to unreadable values in target table.

    According to the error message you provided, which seems is related to Oracle issue, caused by  the requested read operation could not complete because a partial multibyte character was found at the end of the input.

    Based on my research, the user action is to ensure that the complete multibyte character is sent from the remote server and retry the operation. Or read the partial multibyte character as RAW.
    For more information, please refer to here Oracle® Database Error Messages: 16 ORA-29250 to ORA-32775

    For further help, please link to Oracle forums. 

    Regards, Amber zhang

    5. března 2012 2:47