oracle ko16mswin949,ORACLE字符集与编号对照表

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