Oracle toSQL2008 (Problem with convertation UTF-8 data)

Question

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. 

Answer 1

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