conversion.out

PostgreSQL 8.1.4的源码 适用于Linux下的开源数据库系统

-- WIN1251 --> UTF8
SELECT CONVERT('foo' USING windows_1251_to_utf8);
 convert_using 
---------------
 foo
(1 row)

SELECT CONVERT('foo', 'WIN1251', 'UTF8');
 convert 
---------
 foo
(1 row)

-- UTF8 --> WIN1252
SELECT CONVERT('foo' USING utf8_to_windows_1252);
 convert_using 
---------------
 foo
(1 row)

SELECT CONVERT('foo', 'UTF8', 'WIN1252');
 convert 
---------
 foo
(1 row)

-- WIN1252 --> UTF8
SELECT CONVERT('foo' USING windows_1252_to_utf8);
 convert_using 
---------------
 foo
(1 row)

SELECT CONVERT('foo', 'WIN1252', 'UTF8');
 convert 
---------
 foo
(1 row)

-- UTF8 --> WIN866
SELECT CONVERT('foo' USING utf8_to_windows_866);
 convert_using 
---------------
 foo
(1 row)

SELECT CONVERT('foo', 'UTF8', 'WIN866');
 convert 
---------
 foo
(1 row)

-- WIN866 --> UTF8
SELECT CONVERT('foo' USING windows_866_to_utf8);
 convert_using 
---------------
 foo
(1 row)

SELECT CONVERT('foo', 'WIN866', 'UTF8');
 convert 
---------
 foo
(1 row)

-- EUC_CN --> UTF8
SELECT CONVERT('foo' USING euc_cn_to_utf8);
 convert_using 
---------------
 foo
(1 row)

SELECT CONVERT('foo', 'EUC_CN', 'UTF8');
 convert 
---------
 foo
(1 row)

-- UTF8 --> EUC_CN
SELECT CONVERT('foo' USING utf8_to_euc_cn);
 convert_using 
---------------
 foo
(1 row)

SELECT CONVERT('foo', 'UTF8', 'EUC_CN');
 convert 
---------
 foo
(1 row)

-- EUC_JP --> UTF8
SELECT CONVERT('foo' USING euc_jp_to_utf8);
 convert_using 
---------------
 foo
(1 row)

SELECT CONVERT('foo', 'EUC_JP', 'UTF8');
 convert 
---------
 foo
(1 row)

-- UTF8 --> EUC_JP
SELECT CONVERT('foo' USING utf8_to_euc_jp);
 convert_using 
---------------
 foo
(1 row)

SELECT CONVERT('foo', 'UTF8', 'EUC_JP');
 convert 
---------
 foo
(1 row)

-- EUC_KR --> UTF8
SELECT CONVERT('foo' USING euc_kr_to_utf8);
 convert_using 
---------------
 foo
(1 row)

SELECT CONVERT('foo', 'EUC_KR', 'UTF8');
 convert 
---------
 foo
(1 row)

-- UTF8 --> EUC_KR
SELECT CONVERT('foo' USING utf8_to_euc_kr);
 convert_using 
---------------
 foo
(1 row)

SELECT CONVERT('foo', 'UTF8', 'EUC_KR');
 convert 
---------
 foo
(1 row)

-- EUC_TW --> UTF8
SELECT CONVERT('foo' USING euc_tw_to_utf8);
 convert_using 
---------------
 foo
(1 row)

SELECT CONVERT('foo', 'EUC_TW', 'UTF8');
 convert 
---------
 foo
(1 row)

-- UTF8 --> EUC_TW
SELECT CONVERT('foo' USING utf8_to_euc_tw);
 convert_using 
---------------
 foo
(1 row)

SELECT CONVERT('foo', 'UTF8', 'EUC_TW');
 convert 
---------
 foo
(1 row)

-- GB18030 --> UTF8
SELECT CONVERT('foo' USING gb18030_to_utf8);
 convert_using 
---------------
 foo
(1 row)

SELECT CONVERT('foo', 'GB18030', 'UTF8');
 convert 
---------
 foo
(1 row)

-- UTF8 --> GB18030
SELECT CONVERT('foo' USING utf8_to_gb18030);
 convert_using 
---------------
 foo
(1 row)

SELECT CONVERT('foo', 'UTF8', 'GB18030');
 convert 
---------
 foo
(1 row)

-- GBK --> UTF8
SELECT CONVERT('foo' USING gbk_to_utf8);
 convert_using 
---------------
 foo
(1 row)

SELECT CONVERT('foo', 'GBK', 'UTF8');
 convert 
---------
 foo
(1 row)

-- UTF8 --> GBK
SELECT CONVERT('foo' USING utf8_to_gbk);
 convert_using 
---------------
 foo
(1 row)

SELECT CONVERT('foo', 'UTF8', 'GBK');
 convert 
---------
 foo
(1 row)

-- UTF8 --> LATIN2
SELECT CONVERT('foo' USING utf8_to_iso_8859_2);
 convert_using 
---------------
 foo
(1 row)

SELECT CONVERT('foo', 'UTF8', 'LATIN2');
 convert 
---------
 foo
(1 row)

-- LATIN2 --> UTF8
SELECT CONVERT('foo' USING iso_8859_2_to_utf8);
 convert_using 
---------------
 foo
(1 row)

SELECT CONVERT('foo', 'LATIN2', 'UTF8');
 convert 
---------
 foo
(1 row)

-- UTF8 --> LATIN3
SELECT CONVERT('foo' USING utf8_to_iso_8859_3);
 convert_using 
---------------
 foo
(1 row)

SELECT CONVERT('foo', 'UTF8', 'LATIN3');
 convert 
---------
 foo
(1 row)

-- LATIN3 --> UTF8
SELECT CONVERT('foo' USING iso_8859_3_to_utf8);
 convert_using 
---------------
 foo
(1 row)

SELECT CONVERT('foo', 'LATIN3', 'UTF8');
 convert 
---------
 foo
(1 row)

-- UTF8 --> LATIN4
SELECT CONVERT('foo' USING utf8_to_iso_8859_4);
 convert_using 
---------------
 foo
(1 row)

SELECT CONVERT('foo', 'UTF8', 'LATIN4');
 convert 
---------
 foo
(1 row)

-- LATIN4 --> UTF8
SELECT CONVERT('foo' USING iso_8859_4_to_utf8);
 convert_using 
---------------
 foo
(1 row)

SELECT CONVERT('foo', 'LATIN4', 'UTF8');
 convert 
---------
 foo
(1 row)

-- UTF8 --> LATIN5
SELECT CONVERT('foo' USING utf8_to_iso_8859_9);
 convert_using 
---------------
 foo
(1 row)

SELECT CONVERT('foo', 'UTF8', 'LATIN5');
 convert 
---------
 foo
(1 row)

-- LATIN5 --> UTF8
SELECT CONVERT('foo' USING iso_8859_9_to_utf8);
 convert_using 
---------------
 foo
(1 row)

SELECT CONVERT('foo', 'LATIN5', 'UTF8');
 convert 
---------
 foo
(1 row)

-- UTF8 --> LATIN6
SELECT CONVERT('foo' USING utf8_to_iso_8859_10);
 convert_using 
---------------
 foo
(1 row)

SELECT CONVERT('foo', 'UTF8', 'LATIN6');
 convert 
---------
 foo
(1 row)

-- LATIN6 --> UTF8
SELECT CONVERT('foo' USING iso_8859_10_to_utf8);
 convert_using 
---------------
 foo
(1 row)

SELECT CONVERT('foo', 'LATIN6', 'UTF8');
 convert 
---------
 foo
(1 row)

-- UTF8 --> LATIN7
SELECT CONVERT('foo' USING utf8_to_iso_8859_13);
 convert_using 
---------------
 foo
(1 row)

SELECT CONVERT('foo', 'UTF8', 'LATIN7');
 convert 
---------
 foo
(1 row)

-- LATIN7 --> UTF8
SELECT CONVERT('foo' USING iso_8859_13_to_utf8);
 convert_using 
---------------
 foo
(1 row)

SELECT CONVERT('foo', 'LATIN7', 'UTF8');
 convert 
---------
 foo
(1 row)

-- UTF8 --> LATIN8
SELECT CONVERT('foo' USING utf8_to_iso_8859_14);
 convert_using 
---------------
 foo
(1 row)

SELECT CONVERT('foo', 'UTF8', 'LATIN8');
 convert 
---------
 foo
(1 row)

-- LATIN8 --> UTF8
SELECT CONVERT('foo' USING iso_8859_14_to_utf8);
 convert_using 
---------------
 foo
(1 row)

SELECT CONVERT('foo', 'LATIN8', 'UTF8');
 convert 
---------
 foo
(1 row)

-- UTF8 --> LATIN9
SELECT CONVERT('foo' USING utf8_to_iso_8859_15);
 convert_using 
---------------
 foo
(1 row)

SELECT CONVERT('foo', 'UTF8', 'LATIN9');
 convert 
---------
 foo
(1 row)

-- LATIN9 --> UTF8
SELECT CONVERT('foo' USING iso_8859_15_to_utf8);
 convert_using 
---------------
 foo
(1 row)

SELECT CONVERT('foo', 'LATIN9', 'UTF8');
 convert 
---------
 foo
(1 row)

-- UTF8 --> LATIN10
SELECT CONVERT('foo' USING utf8_to_iso_8859_16);
 convert_using 
---------------
 foo
(1 row)

SELECT CONVERT('foo', 'UTF8', 'LATIN10');
 convert 
---------
 foo
(1 row)

-- LATIN10 --> UTF8
SELECT CONVERT('foo' USING iso_8859_16_to_utf8);
 convert_using 
---------------
 foo
(1 row)

SELECT CONVERT('foo', 'LATIN10', 'UTF8');
 convert 
---------
 foo
(1 row)

-- UTF8 --> ISO-8859-5
SELECT CONVERT('foo' USING utf8_to_iso_8859_5);
 convert_using 
---------------
 foo
(1 row)

SELECT CONVERT('foo', 'UTF8', 'ISO-8859-5');
 convert 
---------
 foo
(1 row)

-- ISO-8859-5 --> UTF8
SELECT CONVERT('foo' USING iso_8859_5_to_utf8);
 convert_using 
---------------
 foo
(1 row)

SELECT CONVERT('foo', 'ISO-8859-5', 'UTF8');
 convert 
---------
 foo
(1 row)

-- UTF8 --> ISO-8859-6
SELECT CONVERT('foo' USING utf8_to_iso_8859_6);
 convert_using 
---------------
 foo
(1 row)

SELECT CONVERT('foo', 'UTF8', 'ISO-8859-6');
 convert 
---------
 foo
(1 row)

-- ISO-8859-6 --> UTF8
SELECT CONVERT('foo' USING iso_8859_6_to_utf8);
 convert_using 
---------------
 foo
(1 row)

SELECT CONVERT('foo', 'ISO-8859-6', 'UTF8');
 convert 
---------
 foo
(1 row)

-- UTF8 --> ISO-8859-7
SELECT CONVERT('foo' USING utf8_to_iso_8859_7);
 convert_using 
---------------
 foo
(1 row)

SELECT CONVERT('foo', 'UTF8', 'ISO-8859-7');
 convert 
---------
 foo
(1 row)

-- ISO-8859-7 --> UTF8
SELECT CONVERT('foo' USING iso_8859_7_to_utf8);
 convert_using 
---------------
 foo
(1 row)

SELECT CONVERT('foo', 'ISO-8859-7', 'UTF8');
 convert 
---------
 foo
(1 row)

-- UTF8 --> ISO-8859-8
SELECT CONVERT('foo' USING utf8_to_iso_8859_8);
 convert_using 
---------------
 foo
(1 row)

SELECT CONVERT('foo', 'UTF8', 'ISO-8859-8');
 convert 
---------
 foo
(1 row)

-- ISO-8859-8 --> UTF8
SELECT CONVERT('foo' USING iso_8859_8_to_utf8);
 convert_using 
---------------
 foo
(1 row)

SELECT CONVERT('foo', 'ISO-8859-8', 'UTF8');
 convert 
---------
 foo
(1 row)

-- LATIN1 --> UTF8
SELECT CONVERT('foo' USING iso_8859_1_to_utf8);
 convert_using 
---------------
 foo
(1 row)

SELECT CONVERT('foo', 'LATIN1', 'UTF8');
 convert 
---------
 foo
(1 row)

-- UTF8 --> LATIN1
SELECT CONVERT('foo' USING utf8_to_iso_8859_1);
 convert_using 
---------------
 foo
(1 row)

SELECT CONVERT('foo', 'UTF8', 'LATIN1');
 convert 
---------
 foo
(1 row)

-- JOHAB --> UTF8
SELECT CONVERT('foo' USING johab_to_utf8);
 convert_using 
---------------
 foo
(1 row)

SELECT CONVERT('foo', 'JOHAB', 'UTF8');
 convert 
---------
 foo
(1 row)

-- UTF8 --> JOHAB
SELECT CONVERT('foo' USING utf8_to_johab);
 convert_using 
---------------
 foo
(1 row)

SELECT CONVERT('foo', 'UTF8', 'JOHAB');
 convert 
---------
 foo
(1 row)

-- SJIS --> UTF8
SELECT CONVERT('foo' USING sjis_to_utf8);
 convert_using 
---------------
 foo
(1 row)

SELECT CONVERT('foo', 'SJIS', 'UTF8');
 convert 
---------
 foo
(1 row)

-- UTF8 --> SJIS
SELECT CONVERT('foo' USING utf8_to_sjis);
 convert_using 
---------------
 foo
(1 row)

SELECT CONVERT('foo', 'UTF8', 'SJIS');
 convert 
---------
 foo
(1 row)

-- WIN1258 --> UTF8
SELECT CONVERT('foo' USING win1258_to_utf8);
 convert_using 
---------------
 foo
(1 row)

SELECT CONVERT('foo', 'WIN1258', 'UTF8');
 convert 
---------
 foo
(1 row)

-- UTF8 --> WIN1258
SELECT CONVERT('foo' USING utf8_to_win1258);
 convert_using 
---------------
 foo
(1 row)

SELECT CONVERT('foo', 'UTF8', 'WIN1258');
 convert 
---------
 foo
(1 row)

-- UHC --> UTF8
SELECT CONVERT('foo' USING uhc_to_utf8);
 convert_using 
---------------
 foo
(1 row)

SELECT CONVERT('foo', 'UHC', 'UTF8');
 convert 
---------
 foo
(1 row)

-- UTF8 --> UHC
SELECT CONVERT('foo' USING utf8_to_uhc);
 convert_using 
---------------
 foo
(1 row)

SELECT CONVERT('foo', 'UTF8', 'UHC');
 convert 
---------
 foo
(1 row)

-- UTF8 --> WIN1250
SELECT CONVERT('foo' USING utf8_to_windows_1250);
 convert_using 
---------------
 foo
(1 row)

SELECT CONVERT('foo', 'UTF8', 'WIN1250');
 convert 
---------
 foo
(1 row)

-- WIN1250 --> UTF8
SELECT CONVERT('foo' USING windows_1250_to_utf8);
 convert_using 
---------------
 foo
(1 row)

SELECT CONVERT('foo', 'WIN1250', 'UTF8');
 convert 
---------
 foo
(1 row)

-- UTF8 --> WIN1256
SELECT CONVERT('foo' USING utf8_to_windows_1256);
 convert_using 
---------------
 foo
(1 row)

SELECT CONVERT('foo', 'UTF8', 'WIN1256');
 convert 
---------
 foo
(1 row)

-- WIN1256 --> UTF8
SELECT CONVERT('foo' USING windows_1256_to_utf8);
 convert_using 
---------------
 foo
(1 row)

SELECT CONVERT('foo', 'WIN1256', 'UTF8');
 convert 
---------
 foo
(1 row)

-- UTF8 --> WIN874
SELECT CONVERT('foo' USING utf8_to_windows_874);
 convert_using 
---------------
 foo
(1 row)

SELECT CONVERT('foo', 'UTF8', 'WIN874');
 convert 
---------
 foo
(1 row)

-- WIN874 --> UTF8
SELECT CONVERT('foo' USING windows_874_to_utf8);
 convert_using 
---------------
 foo
(1 row)

SELECT CONVERT('foo', 'WIN874', 'UTF8');
 convert 
---------
 foo
(1 row)

--
-- return to the super user
--
RESET SESSION AUTHORIZATION;
DROP USER conversion_test_user;