sql server to oracle utf8 error

[kiachik]

Ok guys, i really need help here.

I'm writing a program to do daily extraction from sql server to oracle.
These data contain Chinese character, Korean, Japanese, Taiwan.

The source from sql server is extracted into a text file, 3 encode to choose from, ANSI/OEM/Unicode.
I chose ANSI format.

Then i'll do the loading job with sqlloader.
In sqlloader i've set the characterset to UTF8.
Although all data successfully loaded, but the problem occur is, these data can't be view on webpage, all characters had become funny funny characters.

Please help~~~

[kiachik]

Well, i did try other option.
Like extract from sqlserver to Unicode format.

when i loaded with sqlloader characterset UTF8, all data went missing (become blank).
then i tried to load with characterset UTF16, it's works, but i have to change the webpage encoding to particular encode such as Big5, Korean, Chinese GB... It's not UTF8 anymore.

[kiachik]

hello hello
expert expert
senior senior