conversion.out

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

--
-- create user defined conversion
--
CREATE USER conversion_test_user WITH NOCREATEDB NOCREATEUSER;
SET SESSION AUTHORIZATION conversion_test_user;
CREATE CONVERSION myconv FOR 'LATIN1' TO 'UTF8' FROM iso8859_1_to_utf8;
--
-- cannot make same name conversion in same schema
--
CREATE CONVERSION myconv FOR 'LATIN1' TO 'UTF8' FROM iso8859_1_to_utf8;
ERROR:  conversion "myconv" already exists
--
-- create default conversion with qualified name
--
CREATE DEFAULT CONVERSION public.mydef FOR 'LATIN1' TO 'UTF8' FROM iso8859_1_to_utf8;
--
-- cannot make default conversion with same shcema/for_encoding/to_encoding
--
CREATE DEFAULT CONVERSION public.mydef2 FOR 'LATIN1' TO 'UTF8' FROM iso8859_1_to_utf8;
ERROR:  default conversion for LATIN1 to UTF8 already exists
-- test comments
COMMENT ON CONVERSION myconv_bad IS 'foo';
ERROR:  conversion "myconv_bad" does not exist
COMMENT ON CONVERSION myconv IS 'bar';
COMMENT ON CONVERSION myconv IS NULL;
--
-- drop user defined conversion
--
DROP CONVERSION myconv;
DROP CONVERSION mydef;
--
-- make sure all pre-defined conversions are fine.
-- SQL_ASCII --> MULE_INTERNAL
SELECT CONVERT('foo' USING ascii_to_mic);
 convert_using 
---------------
 foo
(1 row)

SELECT CONVERT('foo', 'SQL_ASCII', 'MULE_INTERNAL');
 convert 
---------
 foo
(1 row)

-- MULE_INTERNAL --> SQL_ASCII
SELECT CONVERT('foo' USING mic_to_ascii);
 convert_using 
---------------
 foo
(1 row)

SELECT CONVERT('foo', 'MULE_INTERNAL', 'SQL_ASCII');
 convert 
---------
 foo
(1 row)

-- KOI8R --> MULE_INTERNAL
SELECT CONVERT('foo' USING koi8_r_to_mic);
 convert_using 
---------------
 foo
(1 row)

SELECT CONVERT('foo', 'KOI8R', 'MULE_INTERNAL');
 convert 
---------
 foo
(1 row)

-- MULE_INTERNAL --> KOI8R
SELECT CONVERT('foo' USING mic_to_koi8_r);
 convert_using 
---------------
 foo
(1 row)

SELECT CONVERT('foo', 'MULE_INTERNAL', 'KOI8R');
 convert 
---------
 foo
(1 row)

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

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

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

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

-- WIN1251 --> MULE_INTERNAL
SELECT CONVERT('foo' USING windows_1251_to_mic);
 convert_using 
---------------
 foo
(1 row)

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

-- MULE_INTERNAL --> WIN1251
SELECT CONVERT('foo' USING mic_to_windows_1251);
 convert_using 
---------------
 foo
(1 row)

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

-- WIN866 --> MULE_INTERNAL
SELECT CONVERT('foo' USING windows_866_to_mic);
 convert_using 
---------------
 foo
(1 row)

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

-- MULE_INTERNAL --> WIN866
SELECT CONVERT('foo' USING mic_to_windows_866);
 convert_using 
---------------
 foo
(1 row)

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

-- KOI8R --> WIN1251
SELECT CONVERT('foo' USING koi8_r_to_windows_1251);
 convert_using 
---------------
 foo
(1 row)

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

-- WIN1251 --> KOI8R
SELECT CONVERT('foo' USING windows_1251_to_koi8_r);
 convert_using 
---------------
 foo
(1 row)

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

-- KOI8R --> WIN866
SELECT CONVERT('foo' USING koi8_r_to_windows_866);
 convert_using 
---------------
 foo
(1 row)

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

-- WIN866 --> KOI8R
SELECT CONVERT('foo' USING windows_866_to_koi8_r);
 convert_using 
---------------
 foo
(1 row)

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

-- WIN866 --> WIN1251
SELECT CONVERT('foo' USING windows_866_to_windows_1251);
 convert_using 
---------------
 foo
(1 row)

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

-- WIN1251 --> WIN866
SELECT CONVERT('foo' USING windows_1251_to_windows_866);
 convert_using 
---------------
 foo
(1 row)

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

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

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

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

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

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

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

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

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

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

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

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

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

-- EUC_CN --> MULE_INTERNAL
SELECT CONVERT('foo' USING euc_cn_to_mic);
 convert_using 
---------------
 foo
(1 row)

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

-- MULE_INTERNAL --> EUC_CN
SELECT CONVERT('foo' USING mic_to_euc_cn);
 convert_using 
---------------
 foo
(1 row)

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

-- EUC_JP --> SJIS
SELECT CONVERT('foo' USING euc_jp_to_sjis);
 convert_using 
---------------
 foo
(1 row)

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

-- SJIS --> EUC_JP
SELECT CONVERT('foo' USING sjis_to_euc_jp);
 convert_using 
---------------
 foo
(1 row)

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

-- EUC_JP --> MULE_INTERNAL
SELECT CONVERT('foo' USING euc_jp_to_mic);
 convert_using 
---------------
 foo
(1 row)

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

-- SJIS --> MULE_INTERNAL
SELECT CONVERT('foo' USING sjis_to_mic);
 convert_using 
---------------
 foo
(1 row)

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

-- MULE_INTERNAL --> EUC_JP
SELECT CONVERT('foo' USING mic_to_euc_jp);
 convert_using 
---------------
 foo
(1 row)

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

-- MULE_INTERNAL --> SJIS
SELECT CONVERT('foo' USING mic_to_sjis);
 convert_using 
---------------
 foo
(1 row)

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

-- EUC_KR --> MULE_INTERNAL
SELECT CONVERT('foo' USING euc_kr_to_mic);
 convert_using 
---------------
 foo
(1 row)

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

-- MULE_INTERNAL --> EUC_KR
SELECT CONVERT('foo' USING mic_to_euc_kr);
 convert_using 
---------------
 foo
(1 row)

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

-- EUC_TW --> BIG5
SELECT CONVERT('foo' USING euc_tw_to_big5);
 convert_using 
---------------
 foo
(1 row)

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

-- BIG5 --> EUC_TW
SELECT CONVERT('foo' USING big5_to_euc_tw);
 convert_using 
---------------
 foo
(1 row)

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

-- EUC_TW --> MULE_INTERNAL
SELECT CONVERT('foo' USING euc_tw_to_mic);
 convert_using 
---------------
 foo
(1 row)

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

-- BIG5 --> MULE_INTERNAL
SELECT CONVERT('foo' USING big5_to_mic);
 convert_using 
---------------
 foo
(1 row)

SELECT CONVERT('foo', 'BIG5', 'MULE_INTERNAL');
 convert 
---------
 foo
(1 row)

-- MULE_INTERNAL --> EUC_TW
SELECT CONVERT('foo' USING mic_to_euc_tw);
 convert_using 
---------------
 foo
(1 row)

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

-- MULE_INTERNAL --> BIG5
SELECT CONVERT('foo' USING mic_to_big5);
 convert_using 
---------------
 foo
(1 row)

SELECT CONVERT('foo', 'MULE_INTERNAL', 'BIG5');
 convert 
---------
 foo
(1 row)

-- LATIN2 --> MULE_INTERNAL
SELECT CONVERT('foo' USING iso_8859_2_to_mic);
 convert_using 
---------------
 foo
(1 row)

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

-- MULE_INTERNAL --> LATIN2
SELECT CONVERT('foo' USING mic_to_iso_8859_2);
 convert_using 
---------------
 foo
(1 row)

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

-- WIN1250 --> MULE_INTERNAL
SELECT CONVERT('foo' USING windows_1250_to_mic);
 convert_using 
---------------
 foo
(1 row)

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

-- MULE_INTERNAL --> WIN1250
SELECT CONVERT('foo' USING mic_to_windows_1250);
 convert_using 
---------------
 foo
(1 row)

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

-- LATIN2 --> WIN1250
SELECT CONVERT('foo' USING iso_8859_2_to_windows_1250);
 convert_using 
---------------
 foo
(1 row)

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

-- WIN1250 --> LATIN2
SELECT CONVERT('foo' USING windows_1250_to_iso_8859_2);
 convert_using 
---------------
 foo
(1 row)

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

-- LATIN1 --> MULE_INTERNAL
SELECT CONVERT('foo' USING iso_8859_1_to_mic);
 convert_using 
---------------
 foo
(1 row)

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

-- MULE_INTERNAL --> LATIN1
SELECT CONVERT('foo' USING mic_to_iso_8859_1);
 convert_using 
---------------
 foo
(1 row)

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

-- LATIN3 --> MULE_INTERNAL
SELECT CONVERT('foo' USING iso_8859_3_to_mic);
 convert_using 
---------------
 foo
(1 row)

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

-- MULE_INTERNAL --> LATIN3
SELECT CONVERT('foo' USING mic_to_iso_8859_3);
 convert_using 
---------------
 foo
(1 row)

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

-- LATIN4 --> MULE_INTERNAL
SELECT CONVERT('foo' USING iso_8859_4_to_mic);
 convert_using 
---------------
 foo
(1 row)

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

-- MULE_INTERNAL --> LATIN4
SELECT CONVERT('foo' USING mic_to_iso_8859_4);
 convert_using 
---------------
 foo
(1 row)

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

-- SQL_ASCII --> UTF8
SELECT CONVERT('foo' USING ascii_to_utf8);
 convert_using 
---------------
 foo
(1 row)

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

-- UTF8 --> SQL_ASCII
SELECT CONVERT('foo' USING utf8_to_ascii);
 convert_using 
---------------
 foo
(1 row)

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

-- BIG5 --> UTF8
SELECT CONVERT('foo' USING big5_to_utf8);
 convert_using 
---------------
 foo
(1 row)

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

-- UTF8 --> BIG5
SELECT CONVERT('foo' USING utf8_to_big5);
 convert_using 
---------------
 foo
(1 row)

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

-- UTF8 --> KOI8R
SELECT CONVERT('foo' USING utf8_to_koi8_r);
 convert_using 
---------------
 foo
(1 row)

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

-- KOI8R --> UTF8
SELECT CONVERT('foo' USING koi8_r_to_utf8);
 convert_using 
---------------
 foo
(1 row)

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

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

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