本文档详细记录了一次在Oracle数据库中，从US7ASCII字符集导出数据到ZHS16GBK字符集的数据库时遇到的中文乱码问题。通过分析和尝试，最终找到了成功导入并保持中文数据正确显示的方法，解决了字符集转换的问题。
Z:\>set ORACLE_SID=TEST
Z:\>set NLS_LANG=AMERICAN_AMERICA.US7ASCII
Z:\>sqlplus mydb
SQL*Plus: Release 10.2.0.4.0 - Production on Wed Feb 25 09:42:10 2009
Copyright (c) 1982, 2007, Oracle. All Rights Reserved.
Enter password:
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
MYDB > show parameter db_name
NAME TYPE VALUE
---------------------------------------- ----------- --------------------------------------------------
db_name string TEST
MYDB > select * from nls_database_parameters;
PARAMETER VALUE
------------------------- ----------------------------------------
NLS_LANGUAGE SIMPLIFIED CHINESE
NLS_TERRITORY CHINA
NLS_CURRENCY ?
NLS_ISO_CURRENCY CHINA
NLS_NUMERIC_CHARACTERS .,
NLS_CHARACTERSET US7ASCII
NLS_CALENDAR GREGORIAN
NLS_DATE_FORMAT DD-MON-RR
NLS_DATE_LANGUAGE SIMPLIFIED CHINESE
NLS_SORT BINARY
NLS_TIME_FORMAT HH.MI.SSXFF AM
NLS_TIMESTAMP_FORMAT DD-MON-RR HH.MI.SSXFF AM
NLS_TIME_TZ_FORMAT HH.MI.SSXFF AM TZR
NLS_TIMESTAMP_TZ_FORMAT DD-MON-RR HH.MI.SSXFF AM TZR
NLS_DUAL_CURRENCY ?
NLS_COMP BINARY
NLS_LENGTH_SEMANTICS BYTE
NLS_NCHAR_CONV_EXCP FALSE
NLS_NCHAR_CHARACTERSET AL16UTF16
NLS_RDBMS_VERSION 10.2.0.4.0
20 rows selected.
Elapsed: 00:00:00.01
MYDB > desc chtest;
Name Null? Type
----------------------------------------------------------------------------- -------- ----------------------------------------------------
A
最低0.47元/天 解锁文章
扫一扫
981
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
