Skip to content

Instantly share code, notes, and snippets.

@noborus
Last active August 29, 2015 13:57
Show Gist options
  • Save noborus/9612826 to your computer and use it in GitHub Desktop.
Save noborus/9612826 to your computer and use it in GitHub Desktop.
SELECT e.euc,convert(e.euc,'EUC_JIS_2004','UTF-8') as utf8, convert_from(convert(e.euc,'EUC_JIS_2004','UTF-8'),'UTF-8') as chr FROM (SELECT decode('8f'||to_hex('xa1a1'::bit(16)::int+generate_series(0,93)),'hex') as euc ) as e;
euc | utf8 | chr
----------+------------+-----
\x8fa1a1 | \xf0a08289 | 𠂉
\x8fa1a2 | \xe4b882 | 丂
\x8fa1a3 | \xe4b88f | 丏
\x8fa1a4 | \xe4b892 | 丒
\x8fa1a5 | \xe4b8a9 | 丩
\x8fa1a6 | \xe4b8ab | 丫
\x8fa1a7 | \xe4b8ae | 丮
\x8fa1a8 | \xe4b980 | 乀
\x8fa1a9 | \xe4b987 | 乇
\x8fa1aa | \xe4b988 | 么
\x8fa1ab | \xf0a082a2 | 𠂢
\x8fa1ac | \xe4b991 | 乑
\x8fa1ad | \xe39086 | 㐆
\x8fa1ae | \xf0a082a4 | 𠂤
\x8fa1af | \xe4b99a | 乚
\x8fa1b0 | \xe4b9a9 | 乩
\x8fa1b1 | \xe4ba9d | 亝
\x8fa1b2 | \xe390ac | 㐬
\x8fa1b3 | \xe390ae | 㐮
\x8fa1b4 | \xe4bab9 | 亹
\x8fa1b5 | \xe4babb | 亻
\x8fa1b6 | \xf0a086a2 | 𠆢
\x8fa1b7 | \xe4babc | 亼
\x8fa1b8 | \xe4bb83 | 仃
\x8fa1b9 | \xe4bb88 | 仈
\x8fa1ba | \xe4bb90 | 仐
\x8fa1bb | \xe4bbab | 仫
\x8fa1bc | \xe4bb9a | 仚
\x8fa1bd | \xe4bbb1 | 仱
\x8fa1be | \xe4bbb5 | 仵
\x8fa1bf | \xe4bc80 | 伀
\x8fa1c0 | \xe4bc96 | 伖
\x8fa1c1 | \xe4bda4 | 佤
\x8fa1c2 | \xe4bcb7 | 伷
\x8fa1c3 | \xe4bcbe | 伾
\x8fa1c4 | \xe4bd94 | 佔
\x8fa1c5 | \xe4bd98 | 佘
\x8fa1c6 | \xf0a08893 | 𠈓
\x8fa1c7 | \xe4bdb7 | 佷
\x8fa1c8 | \xe4bdb8 | 佸
\x8fa1c9 | \xe4bdba | 佺
\x8fa1ca | \xe4bdbd | 佽
\x8fa1cb | \xe4be82 | 侂
\x8fa1cc | \xe4be85 | 侅
\x8fa1cd | \xe4be92 | 侒
\x8fa1ce | \xe4be9a | 侚
\x8fa1cf | \xe4bfa6 | 俦
\x8fa1d0 | \xe4beb2 | 侲
\x8fa1d1 | \xe4bebe | 侾
\x8fa1d2 | \xe4bf85 | 俅
\x8fa1d3 | \xe4bf8b | 俋
\x8fa1d4 | \xe4bf8f | 俏
\x8fa1d5 | \xe4bf92 | 俒
\x8fa1d6 | \xe391aa | 㑪
\x8fa1d7 | \xe4bfb2 | 俲
\x8fa1d8 | \xe58080 | 倀
\x8fa1d9 | \xe58090 | 倐
\x8fa1da | \xe58093 | 倓
\x8fa1db | \xe5809c | 倜
\x8fa1dc | \xe5809e | 倞
\x8fa1dd | \xe580a2 | 倢
\x8fa1de | \xe391a8 | 㑨
\x8fa1df | \xe58182 | 偂
\x8fa1e0 | \xe58186 | 偆
\x8fa1e1 | \xe5818e | 偎
\x8fa1e2 | \xe58193 | 偓
\x8fa1e3 | \xe58197 | 偗
\x8fa1e4 | \xe581a3 | 偣
\x8fa1e5 | \xe581a6 | 偦
\x8fa1e6 | \xe581aa | 偪
\x8fa1e7 | \xe581b0 | 偰
\x8fa1e8 | \xe582a3 | 傣
\x8fa1e9 | \xe58288 | 傈
\x8fa1ea | \xe58292 | 傒
\x8fa1eb | \xe58293 | 傓
\x8fa1ec | \xe58295 | 傕
\x8fa1ed | \xe58296 | 傖
\x8fa1ee | \xe5829c | 傜
\x8fa1ef | \xe582aa | 傪
\x8fa1f0 | \xf0a08cab | 𠌫
\x8fa1f1 | \xe582b1 | 傱
\x8fa1f2 | \xe582ba | 傺
\x8fa1f3 | \xe582bb | 傻
\x8fa1f4 | \xe58384 | 僄
\x8fa1f5 | \xe58387 | 僇
\x8fa1f6 | \xe583b3 | 僳
\x8fa1f7 | \xf0a08e81 | 𠎁
\x8fa1f8 | \xe5838e | 僎
\x8fa1f9 | \xf0a08db1 | 𠍱
\x8fa1fa | \xe58394 | 僔
\x8fa1fb | \xe58399 | 僙
\x8fa1fc | \xe583a1 | 僡
\x8fa1fd | \xe583a9 | 僩
\x8fa1fe | \xe39292 | 㒒
(94 rows)
@noborus
Copy link
Author

noborus commented Mar 18, 2014

EUC_JIS_2004に存在しないコードを入れてしまうとエラーになってしまう...

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment