SQL Server export to Oracle UTF8 error -
12-08-2005
, 03:35 AM
Ok guys, i really need help here.
I have a DTS that 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 did the loading job with sqlloader to Oracle.
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~~~
Well, i did try other option.
Extract from sqlserver to Unicode format instead of ANSI.
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.
Can anyone tell me how to export data from SQL Server in UTF8 format or is
there any other way to do this. |