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

Thread: insert korean character in utf8 database

  1. #1
    Join Date
    May 2003
    Posts
    10

    insert korean character in utf8 database

    Hello,

    Can anyone help me with the following problem:

    I have a Oracle 8.1.7 database with UTF8 characterset. I want to insert a korean character ±è in the database from my PC which has nls_lang set to UTF8. Sometimes (mostly) it works well but in certain cases it failes because the character is a composition of several other characters. In this case the '-character causes the problems.
    In the insert-query the korean character is placed between singe-quotes and I think that because the korean character has also a single-quote in it oracle can't insert it because "the string is not properly ended". The numeric value of the problem-character seems to be 180. Does anyone know how I can work around this? btw. it is no problem wth the chinese or japanese language.

    Thanks in advance,

    Jean-Paul

  2. #2
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    Use CHR(ASCII_EQUIVALENT)..

    I guess ASCII_EQUIVALENT for ±è is 201
    funky...

    "I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."

    "Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"

  3. #3
    Join Date
    May 2003
    Posts
    10
    unfortunatly, does not work....

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