[转载] unicode into oracle? - 未名空间MITBBS历史存档

国际科技财经博客移民网络热点娱乐民生时事公众号

Redian新闻

>未名空间

>Database - 数据库

[转载] unicode into oracle?

[转载] unicode into oracle?# Database - 数据库

b*e2002-10-24 07:10

1 楼

【以下文字转载自 Java 讨论区】
【原文由 breeze 所发表】
i have a unicode string that i want to store to an oracle table.. i
tried varchar2 and long, but the result is not readable when I read
them out in a jdbc select nor in toad (with a chinese viwer)
if i print the string before it's inserted into oracle it's fine..
so that means something went wrong during the insert.. what could it
be? my oracle is already set to American/America/UTF8 (the NLS_LANG
setting) and it's oracle 8.1.7.. and i'm using the oci8 dri

g*n2002-10-24 07:10

2 楼

The problem lies in your Chinese viewer. The type VARCHAR2 and getString
should work fine. Try to enable the chinese locale in your NT regional options

dbPassword);
('2343', ?, 'CHINESE')";
BufferedReader(rs2.getCharacterStream("name"));

【在 b****e 的大作中提到】

: 【以下文字转载自 Java 讨论区】
: 【原文由 breeze 所发表】
: i have a unicode string that i want to store to an oracle table.. i
: tried varchar2 and long, but the result is not readable when I read
: them out in a jdbc select nor in toad (with a chinese viwer)
: if i print the string before it's inserted into oracle it's fine..
: so that means something went wrong during the insert.. what could it
: be? my oracle is already set to American/America/UTF8 (the NLS_LANG
: setting) and it's oracle 8.1.7.. and i'm using the oci8 dri

b*e2002-10-24 07:10

3 楼

well the problem is.. chinese is just an example. i have a file with all kinds
of unicode characters (chinese, japanese, korean, etc) and i need to be able
to save all of them into oracle.

【在 g****n 的大作中提到】

: The problem lies in your Chinese viewer. The type VARCHAR2 and getString
: should work fine. Try to enable the chinese locale in your NT regional options
:
: dbPassword);
: ('2343', ?, 'CHINESE')";
: BufferedReader(rs2.getCharacterStream("name"));

g*n2002-10-24 07:10

4 楼

Then you need to install multiple languages onto your system. UTF8 is only an
encoding mechnism, but you have to have the right software to display the
characters on the screen. To make sure you have the right data stored, why
don't you check the bytes instead of viewing it?

kinds
options
oracle.jdbc.driver.OracleDriver());
dbUserId,
as

【在 b****e 的大作中提到】

: well the problem is.. chinese is just an example. i have a file with all kinds
: of unicode characters (chinese, japanese, korean, etc) and i need to be able
: to save all of them into oracle.