客户端 sqlplus 查看也乱码 SQL*Plus: Release 9.2.0.1.0 - Production on 星期二 11月 4 10:07:14 2008Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. 连接到: Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production With the OLAP and Oracle Data Mining options JServer Release 9.2.0.1.0 - ProductionSQL> select * from marc0 where rownum <100; MARC TAG_POSITION ABSOLUTE_TAG TAG_NUMBER IN IN ---------- ------------ ------------ ---------- -- -- TAG ------------------------------------------------------------------------ 821710 24 38 396 1 1163 1 1 0 nam2 c2 1163 2 2 1 JLU074975 MARC TAG_POSITION ABSOLUTE_TAG TAG_NUMBER IN IN ---------- ------------ ------------ ---------- -- -- TAG ------------------------------------------------------------------------ 1163 3 3 10 7-5062-3339-8|d$42.50 1163 4 4 35 j11109 1163 5 5 100 19971114d1997 m y0chiy0120 ea MARC TAG_POSITION ABSOLUTE_TAG TAG_NUMBER IN IN ---------- ------------ ------------ ---------- -- -- TAG ------------------------------------------------------------------------ 1163 6 6 101 0 chi 1156 1 1 0 am n0 1156 2 2 1 0970140748 MARC TAG_POSITION ABSOLUTE_TAG TAG_NUMBER IN IN ---------- ------------ ------------ ---------- -- -- TAG ------------------------------------------------------------------------ 1156 3 3 10 7-5005-3265-2|d30.00 1156 4 4 35 j11102 1156 5 5 102 CN MARC TAG_POSITION ABSOLUTE_TAG TAG_NUMBER IN IN ---------- ------------ ------------ ---------- -- -- TAG ------------------------------------------------------------------------ 1156 6 6 200 1 1997?ê?á??ê|×ê????ê?ó|ê???μ?|f±?êé±àD′×é? 1156 7 7 210 ±±??|c?D1ú2??t?-??3?°?é?|d19961001 1156 8 8 215 435|d26cm MARC TAG_POSITION ABSOLUTE_TAG TAG_NUMBER IN IN ---------- ------------ ------------ ---------- -- -- TAG
--用这个查看你数据库的字符集 select * from nls_database_parameters where parameter like '%NLS_CHAR%'--查看你的nls_lang设置, 或用set 设置(用pl/sql deverlop的话,在注册表里设置nls_lang) c:\>set nls_lang=SIMPLIFIED CHINESE_CHINA.ZHS16GBK把这个ZHS16GBK设成上面查到的数据库字符集。
SQL*Plus: Release 9.2.0.1.0 - Production on 星期二 11月 4 10:07:14 2008Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
连接到:
Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
With the OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - ProductionSQL> select * from marc0 where rownum <100; MARC TAG_POSITION ABSOLUTE_TAG TAG_NUMBER IN IN
---------- ------------ ------------ ---------- -- --
TAG
------------------------------------------------------------------------
821710 24 38 396
1 1163 1 1 0
nam2 c2 1163 2 2 1
JLU074975
MARC TAG_POSITION ABSOLUTE_TAG TAG_NUMBER IN IN
---------- ------------ ------------ ---------- -- --
TAG
------------------------------------------------------------------------
1163 3 3 10
7-5062-3339-8|d$42.50 1163 4 4 35
j11109 1163 5 5 100
19971114d1997 m y0chiy0120 ea
MARC TAG_POSITION ABSOLUTE_TAG TAG_NUMBER IN IN
---------- ------------ ------------ ---------- -- --
TAG
------------------------------------------------------------------------
1163 6 6 101 0
chi 1156 1 1 0
am n0 1156 2 2 1
0970140748
MARC TAG_POSITION ABSOLUTE_TAG TAG_NUMBER IN IN
---------- ------------ ------------ ---------- -- --
TAG
------------------------------------------------------------------------
1156 3 3 10
7-5005-3265-2|d30.00 1156 4 4 35
j11102 1156 5 5 102
CN
MARC TAG_POSITION ABSOLUTE_TAG TAG_NUMBER IN IN
---------- ------------ ------------ ---------- -- --
TAG
------------------------------------------------------------------------
1156 6 6 200 1
1997?ê?á??ê|×ê????ê?ó|ê???μ?|f±?êé±àD′×é? 1156 7 7 210
±±??|c?D1ú2??t?-??3?°?é?|d19961001 1156 8 8 215
435|d26cm
MARC TAG_POSITION ABSOLUTE_TAG TAG_NUMBER IN IN
---------- ------------ ------------ ---------- -- --
TAG
select * from nls_database_parameters where parameter like '%NLS_CHAR%'--查看你的nls_lang设置, 或用set 设置(用pl/sql deverlop的话,在注册表里设置nls_lang)
c:\>set nls_lang=SIMPLIFIED CHINESE_CHINA.ZHS16GBK把这个ZHS16GBK设成上面查到的数据库字符集。