I was wondering if someone has come across this before or
have any clues.
I would like to insert and retrieve strings into Oracle in
different languages from the same client application. The
languages that I need include Western (English/German/
French...), Japanese, Chinese (Tr & Sim) and Korean.
I have the character set on the database (7.2.3 by the way)
to be AL24UTFFSS which is supposed to be a super set of
all languages (UTF-2).
My client application is on Windows NT 4 over SQL*Net and
ODBC.
I tried the following -
set NLS_LANG variable to be AMERICAN_AMERICA.AL24UTFFSS.
With this I get garbage out when I tried to insert a
Japanese (SJIS) string and tried to retrieve it back.
I tried "alter session nls_language=japanese
nls_territory=japan" in my connectiion.
This seemed to handle some characters correctly but others
still came back as garbage (Not sure if Oracle distinguishes
between kanji,hiragana and katakana and supports only one
of these).
Ideally I would like to insert strings without doing the
alter session as it is painful to find out what language
the strings are in every time.
Is there anything I can do to reliably insert strings
in any language (with or without knowing what language)
and retrieving the same string back?
Would appreciate any pointers.
Thanks
Sreedhar