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

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

Redian新闻

>未名空间

>Database - 数据库

[转载] Re: unicode into oracle?

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

b*e2002-10-25 07:10

1 楼

【以下文字转载自 Java 讨论区】
【原文由 breeze 所发表】
still doesn't work :( i don't think what's in oracle is right to
begin with.. i ran select * from table and it didn't show up right
(if i inserted chinese manually using sql and then run it it shows
up fine)
actually the result stored in the DB after i ran my program is
(using select dump (name, 1016) from x_test;)
Typ=1 Len=6 CharacterSet=UTF8: ef,bf,bd,4b,c3,95
the string i isnerted is: str = "\u6587\u6d4b\u8bd5";

g*y2002-10-25 07:10

2 楼

it looks to me that the string did not make the transcoding trip,it is not the
problem of Oracle I guess since you can input it directly into Oracle

oracle.jdbc.driver.OracleDriver());
dbUserId, dbPassword);
('2343', ?, 'CHINESE')";
BufferedReader(rs2.getCharacterStream("name"));
as

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

: 【以下文字转载自 Java 讨论区】
: 【原文由 breeze 所发表】
: still doesn't work :( i don't think what's in oracle is right to
: begin with.. i ran select * from table and it didn't show up right
: (if i inserted chinese manually using sql and then run it it shows
: up fine)
: actually the result stored in the DB after i ran my program is
: (using select dump (name, 1016) from x_test;)
: Typ=1 Len=6 CharacterSet=UTF8: ef,bf,bd,4b,c3,95
: the string i isnerted is: str = "\u6587\u6d4b\u8bd5";