Home » Non-English Forums » Japanese » japanese character set insertion through sqlplus
japanese character set insertion through sqlplus [message #34304] Sat, 04 December 2004 03:15 Go to previous message
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
 
Read Message
Read Message
Previous Topic: Create database with Running custom script (Japanese problem)
Next Topic: 11i Japanese or Chinese on Linux OS
Goto Forum:
  


Current Time: Sun Nov 29 19:45:06 CST 2020