We are creating a UTF8 data stucture using a SJIS dmp.
It throws a error "value too long to insert into the column".
How to tackle this problem?
The problem in the UTF8 -> it coding national symbolses in 2 bytes, so if you have field size 4, you will be able to insert this: 'word', but you will not be able to insert this line: 'æŽææ', as size of that line not 8 bytes.
So you have to review size of fields.
I did it from US7ASCII to UTF8 and I'v got a problem - national characters have been converted to up side down question mark, so you have to check it as well.
For decision this problem you have to hack export file - just change 3 byte on character number 31, but that is not all - you don't have to make full export, make export by owners.
I have the same problem, upside down question marks in CLOB's data. How did you fix this problem? I'm converting (trying to, at least) from WE8ISO8859P1 to UTF8.
Thanks for any help you can give me!
Click Here to Expand Forum to Full Width