如何将中文字符集的数据导入US7ASCII

牛牛 · 发表于 2003-12-30 11:44

我的数据库字符集zhs16gbk,想将数据导入至US7ASCII库中，但中文乱码，是否只能将其中的一个库重装才能解决问题？
两台机器都是9.2.0.1

jacky001 · 发表于 2003-12-30 12:06

我也想知道，等候

BruDog · 发表于 2003-12-30 12:25

US7ASCII能储存中文吗？不能吧！

忍者神龟 · 发表于 2003-12-30 14:00

faint
谁说us7ascii不能存储中文？
不如试试用database link 直接用create table as select 吧，前提是
要导的表没有什么lob等不被这个方法支持的字段

Luck2002 · 发表于 2003-12-30 14:04

手工修改DMP文件然后在作imp试试。
给你个例子参考,Good Luck

When investigating problems like these it is useful to check the character set used for the export. As said above, this is held in the export dump file. It can be seen by doing a hex dump of the export file as follows (in Unix):

cat expdat.dmp | od -x | head

This will produce output similar to:
0000000 0300 0145 5850 4f52 543a 5630 372e 3033
0000020 2e30 330a 4454 534f 0a52 5441 424c 4553
0000040 0a31 3032 340a 300a 0020 2020 2020 2020
0000060 2020 2020 2020 2020 2020 2020 2020 2020
*
0000140 2020 2020 2020 2020 4d6f 6e20 4e6f 7620
0000160 3130 2031 343a 3031 3a33 3620 3139 3937
0000200 0a54 4142 4c45 2022 454d 5022 0a43 5245
0000220 4154 4520 5441 424c 4520 2245 4d50 2220

The second and the third byte in the file define the character set used for the export.
The 16-bit value is stored big-endian, i.e. the more significant byte first. On little-endian platforms, e.g. Sequent Dynix/PTX, the output will  be slightly different as below:

00000000 0003 4501 5058 524f 3a54 2e37 3330 etc.

In the example above, the second byte is 0x00 and the third byte is 0x01, yielding 0x0001 as the character set ID. This shows that NLS_LANG was set to US7ASCII during the export.

The new Oracle8 functions NLS_CHARSET_NAME and NLS_CHARSET_ID can be used to map character set IDs to character set names. The mapping is also given in <Note 13971.1>.

The values for the most commonly used character sets are below:

Name          ID
----------------------
US7ASCII 0x0001
WE8DEC 0x0002
WE8ISO8859P1 0x001f
EE8ISO8859P2 0x0020
SE8ISO8859P3 0x0021
NE8ISO8850P4 0x0022
CL8ISO8859P5 0x0023
AR8ISO8859P6 0x0024
EL8ISO8859P7 0x0025
IW8ISO8859P8 0x0026
WE8ISO8859P9 0x0027
TH8TISASCII 0x0029
WE8ROMAN8 0x0005
WE8PC850 0x000a
US8PC437 0x0004
EE8PC852 0x0096
EE8MSWIN1250 0x00aa
CL8MSWIN1251 0x00ab
EL8MSWIN1253 0x00ae
WE8MSWIN1252 0x00b2
JA16EUC 0x033e
JA16SJIS 0x0340
ZHT16BIG5 0x0361

In this example i have changed the export file's charset from US7ASCII to WE8ISO8859P1.

D:\>debug D:\expdat.dmp
-d
1481:0100  03 00 01  ... ...EXPORT:V08.00
1481:0110  2E 30 ...

(now change the third byte)
-e 1481:0100 03 00 1F ...
-w
-q