Today I was chasing the relevant ASCII code for certain characters... I know there are plenty of
ASCII tables on the net, but this is an interesting SQL solution, nonetheless.
select rownum "dec"
,chr(rownum) "char"
,to_char(rownum,'XXXX') "hex"
from dual connect by level < 256;
dec char hex
--- ---- ---
1 1
2 2
3 3
4 4
5 5
6 6
7 7
8 8
9 " " 9
10 "
" A
11 B
12 C
13 "
" D
14 E
15 F
16 10
17 11
18 12
19 13
20 14
21 15
22 16
23 17
24 18
25 19
26 1A
27 1B
28 1C
29 1D
30 1E
31 1F
32 20
33 ! 21
34 " 22
35 # 23
36 $ 24
37 % 25
38 & 26
39 ' 27
40 ( 28
41 ) 29
42 * 2A
43 + 2B
44 , 2C
45 - 2D
46 . 2E
47 / 2F
48 0 30
49 1 31
50 2 32
51 3 33
52 4 34
53 5 35
54 6 36
55 7 37
56 8 38
57 9 39
58 : 3A
59 ; 3B
60 < 3C
61 = 3D
62 > 3E
63 ? 3F
64 @ 40
65 A 41
66 B 42
67 C 43
68 D 44
69 E 45
70 F 46
71 G 47
72 H 48
73 I 49
74 J 4A
75 K 4B
76 L 4C
77 M 4D
78 N 4E
79 O 4F
80 P 50
81 Q 51
82 R 52
83 S 53
84 T 54
85 U 55
86 V 56
87 W 57
88 X 58
89 Y 59
90 Z 5A
91 [ 5B
92 \ 5C
93 ] 5D
94 ^ 5E
95 _ 5F
96 ` 60
97 a 61
98 b 62
99 c 63
100 d 64
101 e 65
102 f 66
103 g 67
104 h 68
105 i 69
106 j 6A
107 k 6B
108 l 6C
109 m 6D
110 n 6E
111 o 6F
112 p 70
113 q 71
114 r 72
115 s 73
116 t 74
117 u 75
118 v 76
119 w 77
120 x 78
121 y 79
122 z 7A
123 { 7B
124 | 7C
125 } 7D
126 ~ 7E
127 7F
128 € 80
129 81
130 ‚ 82
131 ƒ 83
132 „ 84
133 … 85
134 † 86
135 ‡ 87
136 ˆ 88
137 ‰ 89
138 Š 8A
139 ‹ 8B
140 Œ 8C
141 8D
142 Ž 8E
143 8F
144 90
145 ‘ 91
146 ’ 92
147 “ 93
148 ” 94
149 • 95
150 – 96
151 — 97
152 ˜ 98
153 ™ 99
154 š 9A
155 › 9B
156 œ 9C
157 9D
158 ž 9E
159 Ÿ 9F
160 A0
161 ¡ A1
162 ¢ A2
163 £ A3
164 ¤ A4
165 ¥ A5
166 ¦ A6
167 § A7
168 ¨ A8
169 © A9
170 ª AA
171 « AB
172 ¬ AC
173 AD
174 ® AE
175 ¯ AF
176 ° B0
177 ± B1
178 ² B2
179 ³ B3
180 ´ B4
181 µ B5
182 ¶ B6
183 · B7
184 ¸ B8
185 ¹ B9
186 º BA
187 » BB
188 ¼ BC
189 ½ BD
190 ¾ BE
191 ¿ BF
192 À C0
193 Á C1
194 Â C2
195 Ã C3
196 Ä C4
197 Å C5
198 Æ C6
199 Ç C7
200 È C8
201 É C9
202 Ê CA
203 Ë CB
204 Ì CC
205 Í CD
206 Î CE
207 Ï CF
208 Ð D0
209 Ñ D1
210 Ò D2
211 Ó D3
212 Ô D4
213 Õ D5
214 Ö D6
215 × D7
216 Ø D8
217 Ù D9
218 Ú DA
219 Û DB
220 Ü DC
221 Ý DD
222 Þ DE
223 ß DF
224 à E0
225 á E1
226 â E2
227 ã E3
228 ä E4
229 å E5
230 æ E6
231 ç E7
232 è E8
233 é E9
234 ê EA
235 ë EB
236 ì EC
237 í ED
238 î EE
239 ï EF
240 ð F0
241 ñ F1
242 ò F2
243 ó F3
244 ô F4
245 õ F5
246 ö F6
247 ÷ F7
248 ø F8
249 ù F9
250 ú FA
251 û FB
252 ü FC
253 ý FD
254 þ FE
255 ÿ FF
I think I'm glad I don't need to work in a multi-language / character set environment.
No comments:
Post a Comment