japanese character set insertion through sqlplus [message #34304] |
Sat, 04 December 2004 03:15 |
Srinath
Messages: 40 Registered: May 2002
|
Member |
|
|
Hi, I have situation below that needs expert advice.
TASK: load into the table (called choicelistitem as seen below) with the
following languages: English, German, French, Italian, <B style="COLOR: black; BACKGROUND-COLOR: #ffff66">Japanese[/b],
Spanish, Korean, Thai, Simplified Chinese, Complex Chinese, Portuguese,
Hungarian, Polish, Greek, Russian, Swedish, Turkish & Czech.
PROBLEM STATEMENT: Loading languages with Western <B style="COLOR: black; BACKGROUND-COLOR: #a0ffff">characters[/b] are OK;
while Eastern <B style="COLOR: black; BACKGROUND-COLOR: #a0ffff">characters[/b] (<B style="COLOR: black; BACKGROUND-COLOR: #ffff66">Japanese[/b], Chinese, etc.) aren't.
On the client side, I received a XLS spreadsheet from our user that
contains all the above languages and I _can_ see/read
both Western & Eastern <B style="COLOR: black; BACKGROUND-COLOR: #a0ffff">characters[/b] just fine. In other words, my client
was able to encode the <B style="COLOR: black; BACKGROUND-COLOR: #a0ffff">characters[/b] for display using Excel.
However, when I attempt to cut-and-paste Eastern <B style="COLOR: black; BACKGROUND-COLOR: #a0ffff">characters[/b] into the
Notepad <B style="COLOR: black; BACKGROUND-COLOR: #ff9999">editor[/b]/SQLPlus prompt/TOAD, it becomes "?????".
Althought, I can cut-and-paste/insert into table Western <B style="COLOR: black; BACKGROUND-COLOR: #a0ffff">characters[/b]
just fine.
In summary, Eastern <B style="COLOR: black; BACKGROUND-COLOR: #a0ffff">characters[/b] return ??? marks after supposedly
configured environment properly (see below for configuration setup's).
Did I missed a step or 2? Any help would be appreciated.
1. Configured the Oracle on WinNT 4 database server with "UTF8"
character set.
oracle version 9.2.0.1.0
please put your adices at the earliest.
thank u.
srinath
|
|
|