Re: Japanese Character storing in Oracle using JDBC(B

Swaminathan Balasubramanian wrote in message <36CC7AF6.DB5F79EB_at_netscape.com>...
>Hi,
>
>I have a japanese character (letter text) which needs to be saved in
>Oracle. Say, the letter is edited using japanese word processor and it
>is cut and paste into our java textarea. It looks fine.
>How do i save this Oracle database and retrieve it?
>I experienced problems even when the oracle database instance is
>upgraded to 2 byte character set.
>
>Can anyone help?
>
>Thanks
>Swami
>

Hi,
What is the version of Oracle? If you want to save Japanese characters in Oracle database via JDBC, you need to save them in unicode format. If you are using Oracle7, set the character set of DB as "AL24UTFFSS". If it is Oracle8, try setting it to "UTF8". If you are using a Thin(Type 4) driver, you are out of luck. It does not yet support multi-byte characters. You have to wait till the new version comes up.

Good luck!
)_)_)_)_)_)_)_)_)_)_)_)_)_)_)_)_)_)_)_)_)_)_)_)_)_)_)

Tom Tanaka
President/Technical Artist
DNA,Inc.
http://www.dnainc.co.jp
tomatell_at_xx.dnainc.co.jp
100% Pure Java Web Search Robot
at the following URL:
http://www.dnainc.co.jp/dnabot/

)_)_)_)_)_)_)_)_)_)_)_)_)_)_)_)_)_)_)_)_)_)_)_)_)_)_) Received on Fri Feb 19 1999 - 00:00:00 CET