ORACLE字符集与编号对照表
先创建一张临时表:
create table test
(
var1 number(5),
var2 varchar2(200),
var3 varchar2(200)
);
--------------------------------------------------------------------------------
-- Created on 2015-9-18 by chenzhuo
declare
-- Local variables here
i integer;
v_var varchar2(500);
begin
-- Test statements here
for i in 1..10000 loop
v_var := nls_charset_name(i);
if (v_var is not null) then
insert into test(var1,var2,var3)
values(i,lpad(trim(to_char(i,'XXXX')),4,'0'),nls_charset_name(i));
end if;
commit;
--dbms_output.put_line(rpad(i,5,' ')||lpad(trim(to_char(i,'XXXX')),4,'0')||' '||nls_charset_name(i));
end loop;
end;
--------------------------------------------------------------------------------
select * from test t order by var1;
--------------------------------------------------------------------------------
1 0001 US7ASCII
2 0002 WE8DEC
3 0003 WE8HP
4 0004 US8PC437
5 0005 WE8EBCDIC37
6 0006 WE8EBCDIC500
7 0007 WE8EBCDIC1140
8 0008 WE8EBCDIC285
9 0009 WE8EBCDIC1146
10 000A WE8PC850
11 000B D7DEC
12 000C F7DEC
13 000D S7DEC
14 000E E7DEC
15 000F SF7ASCII
16 0010 NDK7DEC
17 0011 I7DEC
18 0012 NL7DEC
19 0013 CH7DEC
20 0014 YUG7ASCII
21 0015 SF7DEC
22 0016 TR7DEC
23 0017 IW7IS960
25 0019 IN8ISCII
27 001B WE8EBCDIC1148
28 001C WE8PC858
31 001F WE8ISO8859P1
32 0020 EE8ISO8859P2
33 0021 SE8ISO8859P3
34 0022 NEE8ISO8859P4
35 0023 CL8ISO8859P5
36 0024 AR8ISO8859P6
37 0025 EL8ISO8859P7
38 0026 IW8ISO8859P8
39 0027 WE8ISO8859P9
40 0028 NE8ISO8859P10
41 0029 TH8TISASCII
42 002A TH8TISEBCDIC
43 002B BN8BSCII
44 002C VN8VN3
45 002D VN8MSWIN1258
46 002E WE8ISO8859P15
47 002F BLT8ISO8859P13
48 0030 CEL8ISO8859P14
49 0031 CL8ISOIR111
50 0032 WE8NEXTSTEP
51 0033 CL8KOI8U
52 0034 AZ8ISO8859P9E
61 003D AR8ASMO708PLUS
70 0046 AR8EBCDICX
72 0048 AR8XBASIC
81 0051 EL8DEC
82 0052 TR8DEC
90 005A WE8EBCDIC37C
91 005B WE8EBCDIC500C
92 005C IW8EBCDIC424
93 005D TR8EBCDIC1026
94 005E WE8EBCDIC871
95 005F WE8EBCDIC284
96 0060 WE8EBCDIC1047
97 0061 WE8EBCDIC1140C
98 0062 WE8EBCDIC1145
99 0063 WE8EBCDIC1148C
100 0064 WE8EBCDIC1047E
101 0065 WE8EBCDIC924
110 006E EEC8EUROASCI
113 0071 EEC8EUROPA3
114 0072 LA8PASSPORT
140 008C BG8PC437S
150 0096 EE8PC852
152 0098 RU8PC866
153 0099 RU8BESTA
154 009A IW8PC1507
155 009B RU8PC855
156 009C TR8PC857
158 009E CL8MACCYRILLIC
159 009F CL8MACCYRILLICS
160 00A0 WE8PC860
161 00A1 IS8PC861
162 00A2 EE8MACCES
163 00A3 EE8MACCROATIANS
164 00A4 TR8MACTURKISHS
165 00A5 IS8MACICELANDICS
166 00A6 EL8MACGREEKS
167 00A7 IW8MACHEBREWS
170 00AA EE8MSWIN1250
171 00AB CL8MSWIN1251
172 00AC ET8MSWIN923
173 00AD BG8MSWIN
174 00AE EL8MSWIN1253
175 00AF IW8MSWIN1255
176 00B0 LT8MSWIN921
177 00B1 TR8MSWIN1254
178 00B2 WE8