dbTalk Databases Forums  

SQL Server export to Oracle UTF8 error

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss SQL Server export to Oracle UTF8 error in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
jiajilah
 
Posts: n/a

Default 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.

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.