DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: SJIS -> UTF8

  1. #1
    Join Date
    Apr 2001
    Posts
    19
    Hi,
    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?

    Thanks,
    Steenie

  2. #2
    Join Date
    Mar 2001
    Location
    Ireland/Dublin
    Posts
    688
    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.
    Best wishes!
    Dmitri.

  3. #3
    Join Date
    Feb 2000
    Posts
    3
    kgb,

    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!


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width