Manually convert data from ZHS16GBK to UTF8 on ORACLE 8(Character Set US7ASCII)
From: Dhwan Kim <dhwankim_at_dfibiz.co.kr>
Date: 19 Jul 2004 02:05:25 -0700
Message-ID: <212bd6f8.0407190105.180264c8_at_posting.google.com>
Hi
I want to extract some chinese data. data are stored in ORACLE 8 (DB Character Map is US7ASCII) but data are using NLS_LANG ZHS16GBK internally.
Date: 19 Jul 2004 02:05:25 -0700
Message-ID: <212bd6f8.0407190105.180264c8_at_posting.google.com>
Hi
I want to extract some chinese data. data are stored in ORACLE 8 (DB Character Map is US7ASCII) but data are using NLS_LANG ZHS16GBK internally.
But I met a problem with covertiong to UTF8.
So I have tried to use convert() (function). But I could not figure out the resolution for converting.
If you have any idea. Please let me know that.
Thanks in Advance.
Regard
Dhwan Kim
Received on Mon Jul 19 2004 - 11:05:25 CEST