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

Thread: western european to UTF8

  1. #1
    Join Date
    Feb 2001
    Posts
    83
    Hello,

    I am trying to import data from a DB which has W8ISO... to UTF8 Database . It gives "value too long to insert into the colum" error while importing. Whats the procedure to do that ??
    with regards
    Prasanna S

  2. #2
    Join Date
    Sep 2001
    Location
    NJ, USA
    Posts
    1,287
    This is only my mind, no more.

    This situation may be when in some tables somebody declared field as VARCHAR2 and it works when CHARACTER SET has 1 byte and you have full filling fields.

    When you (or exp/imp utility) insert into CHAR or VARCHAR2 fileds in full filling field (European or Asian lang) length of field may be increase (more then field lenght).

    REFERENCE about UTF-8 Encoding

    UTF-8 is the 8-bit encoding of Unicode. It is a variable-width encoding in which the character codes 0x00 through 0x7F have the same meaning as ASCII. One Unicode
    character can be 1 byte, 2 bytes, 3 bytes or 4 bytes in this encoding. Characters from the European scripts are represented in either 1 or 2 bytes.



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