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

Thread: exp from WE8MSWIN1252/ imp to UTF8

  1. #1
    Join Date
    Mar 2006
    Posts
    176

    exp from WE8MSWIN1252/ imp to UTF8

    Hi all,

    I did an exp on the db with WE8MSWIN1252 and import the file into UTF8 database the import run successful; however, the user had issue with the app, the error is :

    ORA-12899: value too large for column.........

    this is look like the characterset issues but I thought WE8MSWIN1252 is the subset of UTF8.

    any thoughts?

  2. #2
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    4,166
    UTF8 needs extra bytes since it is unicode. You need to increase the size of the offending column on the source system and then export and re-import. You can also grab the sql from the table in question and pre-create the table taking care to increase the size of the offending column before you do.

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