Re: My language is broken in oracle

handlim schrieb:
> One of oracle is set as US7ASCII and another is set as
> KO16KSC5601(Korea language). I use the program, which is made by C
> language, to transfer data between two oracles. But, When I move the
> data from one oralce which is set as KO16KSC5601 to another oracle
> which is set as US7ASCII, The data written by korea language is
> broken.
>
> So, I am wondering how I can do for solving this problem.
> Who knows any way to move data between two oracle which are set
> differently in character set. And I am wondering if there is any
> function in C lanuage to support varient character sets among each
> different languages.
>
> Please, Help me,,,,
>
> Have a good day,,,

You can't store 2 byte (KO16...) Korean letters into an US7ASCII (7 bit only) characterset database. Look at the oracle documentation for NLS (Naturale Language Support)!

To transfer data from one database to another, a C function might not be the best choice. I would suggest the oracle exp/imp utilities!

HTH!
Rainer

-- 
------------------------------------------------
Rainer Herbst         Linux - Registered
ZEIK                  User #319157
Universität Potsdam   Usual disclaimers applies!
------------------------------------------------