| -- |
| -- 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; |
| -- |
| -- 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; |
| -- test comments |
| COMMENT ON CONVERSION myconv_bad IS 'foo'; |
| COMMENT ON CONVERSION myconv IS 'bar'; |
| COMMENT ON CONVERSION myconv IS NULL; |
| -- |
| -- rename conversion |
| -- |
| ALTER CONVERSION myconv RENAME TO myconv1; |
| ALTER CONVERSION myconv1 OWNER TO conversion_test_user; |
| |
| -- |
| -- list all conversions |
| -- |
| \dc; |
| |
| -- |
| -- drop user defined conversion |
| -- |
| DROP CONVERSION myconv1; |
| DROP CONVERSION mydef; |
| -- |
| -- make sure all pre-defined conversions are fine. |
| -- SQL_ASCII --> MULE_INTERNAL |
| SELECT CONVERT('foo' USING ascii_to_mic); |
| SELECT CONVERT('foo', 'SQL_ASCII', 'MULE_INTERNAL'); |
| -- MULE_INTERNAL --> SQL_ASCII |
| SELECT CONVERT('foo' USING mic_to_ascii); |
| SELECT CONVERT('foo', 'MULE_INTERNAL', 'SQL_ASCII'); |
| -- KOI8R --> MULE_INTERNAL |
| SELECT CONVERT('foo' USING koi8_r_to_mic); |
| SELECT CONVERT('foo', 'KOI8R', 'MULE_INTERNAL'); |
| -- MULE_INTERNAL --> KOI8R |
| SELECT CONVERT('foo' USING mic_to_koi8_r); |
| SELECT CONVERT('foo', 'MULE_INTERNAL', 'KOI8R'); |
| -- ISO-8859-5 --> MULE_INTERNAL |
| SELECT CONVERT('foo' USING iso_8859_5_to_mic); |
| SELECT CONVERT('foo', 'ISO-8859-5', 'MULE_INTERNAL'); |
| -- MULE_INTERNAL --> ISO-8859-5 |
| SELECT CONVERT('foo' USING mic_to_iso_8859_5); |
| SELECT CONVERT('foo', 'MULE_INTERNAL', 'ISO-8859-5'); |
| -- WIN1251 --> MULE_INTERNAL |
| SELECT CONVERT('foo' USING windows_1251_to_mic); |
| SELECT CONVERT('foo', 'WIN1251', 'MULE_INTERNAL'); |
| -- MULE_INTERNAL --> WIN1251 |
| SELECT CONVERT('foo' USING mic_to_windows_1251); |
| SELECT CONVERT('foo', 'MULE_INTERNAL', 'WIN1251'); |
| -- WIN866 --> MULE_INTERNAL |
| SELECT CONVERT('foo' USING windows_866_to_mic); |
| SELECT CONVERT('foo', 'WIN866', 'MULE_INTERNAL'); |
| -- MULE_INTERNAL --> WIN866 |
| SELECT CONVERT('foo' USING mic_to_windows_866); |
| SELECT CONVERT('foo', 'MULE_INTERNAL', 'WIN866'); |
| -- KOI8R --> WIN1251 |
| SELECT CONVERT('foo' USING koi8_r_to_windows_1251); |
| SELECT CONVERT('foo', 'KOI8R', 'WIN1251'); |
| -- WIN1251 --> KOI8R |
| SELECT CONVERT('foo' USING windows_1251_to_koi8_r); |
| SELECT CONVERT('foo', 'WIN1251', 'KOI8R'); |
| -- KOI8R --> WIN866 |
| SELECT CONVERT('foo' USING koi8_r_to_windows_866); |
| SELECT CONVERT('foo', 'KOI8R', 'WIN866'); |
| -- WIN866 --> KOI8R |
| SELECT CONVERT('foo' USING windows_866_to_koi8_r); |
| SELECT CONVERT('foo', 'WIN866', 'KOI8R'); |
| -- WIN866 --> WIN1251 |
| SELECT CONVERT('foo' USING windows_866_to_windows_1251); |
| SELECT CONVERT('foo', 'WIN866', 'WIN1251'); |
| -- WIN1251 --> WIN866 |
| SELECT CONVERT('foo' USING windows_1251_to_windows_866); |
| SELECT CONVERT('foo', 'WIN1251', 'WIN866'); |
| -- ISO-8859-5 --> KOI8R |
| SELECT CONVERT('foo' USING iso_8859_5_to_koi8_r); |
| SELECT CONVERT('foo', 'ISO-8859-5', 'KOI8R'); |
| -- KOI8R --> ISO-8859-5 |
| SELECT CONVERT('foo' USING koi8_r_to_iso_8859_5); |
| SELECT CONVERT('foo', 'KOI8R', 'ISO-8859-5'); |
| -- ISO-8859-5 --> WIN1251 |
| SELECT CONVERT('foo' USING iso_8859_5_to_windows_1251); |
| SELECT CONVERT('foo', 'ISO-8859-5', 'WIN1251'); |
| -- WIN1251 --> ISO-8859-5 |
| SELECT CONVERT('foo' USING windows_1251_to_iso_8859_5); |
| SELECT CONVERT('foo', 'WIN1251', 'ISO-8859-5'); |
| -- ISO-8859-5 --> WIN866 |
| SELECT CONVERT('foo' USING iso_8859_5_to_windows_866); |
| SELECT CONVERT('foo', 'ISO-8859-5', 'WIN866'); |
| -- WIN866 --> ISO-8859-5 |
| SELECT CONVERT('foo' USING windows_866_to_iso_8859_5); |
| SELECT CONVERT('foo', 'WIN866', 'ISO-8859-5'); |
| -- EUC_CN --> MULE_INTERNAL |
| SELECT CONVERT('foo' USING euc_cn_to_mic); |
| SELECT CONVERT('foo', 'EUC_CN', 'MULE_INTERNAL'); |
| -- MULE_INTERNAL --> EUC_CN |
| SELECT CONVERT('foo' USING mic_to_euc_cn); |
| SELECT CONVERT('foo', 'MULE_INTERNAL', 'EUC_CN'); |
| -- EUC_JP --> SJIS |
| SELECT CONVERT('foo' USING euc_jp_to_sjis); |
| SELECT CONVERT('foo', 'EUC_JP', 'SJIS'); |
| -- SJIS --> EUC_JP |
| SELECT CONVERT('foo' USING sjis_to_euc_jp); |
| SELECT CONVERT('foo', 'SJIS', 'EUC_JP'); |
| -- EUC_JP --> MULE_INTERNAL |
| SELECT CONVERT('foo' USING euc_jp_to_mic); |
| SELECT CONVERT('foo', 'EUC_JP', 'MULE_INTERNAL'); |
| -- SJIS --> MULE_INTERNAL |
| SELECT CONVERT('foo' USING sjis_to_mic); |
| SELECT CONVERT('foo', 'SJIS', 'MULE_INTERNAL'); |
| -- MULE_INTERNAL --> EUC_JP |
| SELECT CONVERT('foo' USING mic_to_euc_jp); |
| SELECT CONVERT('foo', 'MULE_INTERNAL', 'EUC_JP'); |
| -- MULE_INTERNAL --> SJIS |
| SELECT CONVERT('foo' USING mic_to_sjis); |
| SELECT CONVERT('foo', 'MULE_INTERNAL', 'SJIS'); |
| -- EUC_KR --> MULE_INTERNAL |
| SELECT CONVERT('foo' USING euc_kr_to_mic); |
| SELECT CONVERT('foo', 'EUC_KR', 'MULE_INTERNAL'); |
| -- MULE_INTERNAL --> EUC_KR |
| SELECT CONVERT('foo' USING mic_to_euc_kr); |
| SELECT CONVERT('foo', 'MULE_INTERNAL', 'EUC_KR'); |
| -- EUC_TW --> BIG5 |
| SELECT CONVERT('foo' USING euc_tw_to_big5); |
| SELECT CONVERT('foo', 'EUC_TW', 'BIG5'); |
| -- BIG5 --> EUC_TW |
| SELECT CONVERT('foo' USING big5_to_euc_tw); |
| SELECT CONVERT('foo', 'BIG5', 'EUC_TW'); |
| -- EUC_TW --> MULE_INTERNAL |
| SELECT CONVERT('foo' USING euc_tw_to_mic); |
| SELECT CONVERT('foo', 'EUC_TW', 'MULE_INTERNAL'); |
| -- BIG5 --> MULE_INTERNAL |
| SELECT CONVERT('foo' USING big5_to_mic); |
| SELECT CONVERT('foo', 'BIG5', 'MULE_INTERNAL'); |
| -- MULE_INTERNAL --> EUC_TW |
| SELECT CONVERT('foo' USING mic_to_euc_tw); |
| SELECT CONVERT('foo', 'MULE_INTERNAL', 'EUC_TW'); |
| -- MULE_INTERNAL --> BIG5 |
| SELECT CONVERT('foo' USING mic_to_big5); |
| SELECT CONVERT('foo', 'MULE_INTERNAL', 'BIG5'); |
| -- LATIN2 --> MULE_INTERNAL |
| SELECT CONVERT('foo' USING iso_8859_2_to_mic); |
| SELECT CONVERT('foo', 'LATIN2', 'MULE_INTERNAL'); |
| -- MULE_INTERNAL --> LATIN2 |
| SELECT CONVERT('foo' USING mic_to_iso_8859_2); |
| SELECT CONVERT('foo', 'MULE_INTERNAL', 'LATIN2'); |
| -- WIN1250 --> MULE_INTERNAL |
| SELECT CONVERT('foo' USING windows_1250_to_mic); |
| SELECT CONVERT('foo', 'WIN1250', 'MULE_INTERNAL'); |
| -- MULE_INTERNAL --> WIN1250 |
| SELECT CONVERT('foo' USING mic_to_windows_1250); |
| SELECT CONVERT('foo', 'MULE_INTERNAL', 'WIN1250'); |
| -- LATIN2 --> WIN1250 |
| SELECT CONVERT('foo' USING iso_8859_2_to_windows_1250); |
| SELECT CONVERT('foo', 'LATIN2', 'WIN1250'); |
| -- WIN1250 --> LATIN2 |
| SELECT CONVERT('foo' USING windows_1250_to_iso_8859_2); |
| SELECT CONVERT('foo', 'WIN1250', 'LATIN2'); |
| -- LATIN1 --> MULE_INTERNAL |
| SELECT CONVERT('foo' USING iso_8859_1_to_mic); |
| SELECT CONVERT('foo', 'LATIN1', 'MULE_INTERNAL'); |
| -- MULE_INTERNAL --> LATIN1 |
| SELECT CONVERT('foo' USING mic_to_iso_8859_1); |
| SELECT CONVERT('foo', 'MULE_INTERNAL', 'LATIN1'); |
| -- LATIN3 --> MULE_INTERNAL |
| SELECT CONVERT('foo' USING iso_8859_3_to_mic); |
| SELECT CONVERT('foo', 'LATIN3', 'MULE_INTERNAL'); |
| -- MULE_INTERNAL --> LATIN3 |
| SELECT CONVERT('foo' USING mic_to_iso_8859_3); |
| SELECT CONVERT('foo', 'MULE_INTERNAL', 'LATIN3'); |
| -- LATIN4 --> MULE_INTERNAL |
| SELECT CONVERT('foo' USING iso_8859_4_to_mic); |
| SELECT CONVERT('foo', 'LATIN4', 'MULE_INTERNAL'); |
| -- MULE_INTERNAL --> LATIN4 |
| SELECT CONVERT('foo' USING mic_to_iso_8859_4); |
| SELECT CONVERT('foo', 'MULE_INTERNAL', 'LATIN4'); |
| -- SQL_ASCII --> UTF8 |
| SELECT CONVERT('foo' USING ascii_to_utf8); |
| SELECT CONVERT('foo', 'SQL_ASCII', 'UTF8'); |
| -- UTF8 --> SQL_ASCII |
| SELECT CONVERT('foo' USING utf8_to_ascii); |
| SELECT CONVERT('foo', 'UTF8', 'SQL_ASCII'); |
| -- BIG5 --> UTF8 |
| SELECT CONVERT('foo' USING big5_to_utf8); |
| SELECT CONVERT('foo', 'BIG5', 'UTF8'); |
| -- UTF8 --> BIG5 |
| SELECT CONVERT('foo' USING utf8_to_big5); |
| SELECT CONVERT('foo', 'UTF8', 'BIG5'); |
| -- UTF8 --> KOI8R |
| SELECT CONVERT('foo' USING utf8_to_koi8_r); |
| SELECT CONVERT('foo', 'UTF8', 'KOI8R'); |
| -- KOI8R --> UTF8 |
| SELECT CONVERT('foo' USING koi8_r_to_utf8); |
| SELECT CONVERT('foo', 'KOI8R', 'UTF8'); |
| -- UTF8 --> WIN1251 |
| SELECT CONVERT('foo' USING utf8_to_windows_1251); |
| SELECT CONVERT('foo', 'UTF8', 'WIN1251'); |
| -- WIN1251 --> UTF8 |
| SELECT CONVERT('foo' USING windows_1251_to_utf8); |
| SELECT CONVERT('foo', 'WIN1251', 'UTF8'); |
| -- UTF8 --> WIN1252 |
| SELECT CONVERT('foo' USING utf8_to_windows_1252); |
| SELECT CONVERT('foo', 'UTF8', 'WIN1252'); |
| -- WIN1252 --> UTF8 |
| SELECT CONVERT('foo' USING windows_1252_to_utf8); |
| SELECT CONVERT('foo', 'WIN1252', 'UTF8'); |
| -- UTF8 --> WIN866 |
| SELECT CONVERT('foo' USING utf8_to_windows_866); |
| SELECT CONVERT('foo', 'UTF8', 'WIN866'); |
| -- WIN866 --> UTF8 |
| SELECT CONVERT('foo' USING windows_866_to_utf8); |
| SELECT CONVERT('foo', 'WIN866', 'UTF8'); |
| -- EUC_CN --> UTF8 |
| SELECT CONVERT('foo' USING euc_cn_to_utf8); |
| SELECT CONVERT('foo', 'EUC_CN', 'UTF8'); |
| -- UTF8 --> EUC_CN |
| SELECT CONVERT('foo' USING utf8_to_euc_cn); |
| SELECT CONVERT('foo', 'UTF8', 'EUC_CN'); |
| -- EUC_JP --> UTF8 |
| SELECT CONVERT('foo' USING euc_jp_to_utf8); |
| SELECT CONVERT('foo', 'EUC_JP', 'UTF8'); |
| -- UTF8 --> EUC_JP |
| SELECT CONVERT('foo' USING utf8_to_euc_jp); |
| SELECT CONVERT('foo', 'UTF8', 'EUC_JP'); |
| -- EUC_KR --> UTF8 |
| SELECT CONVERT('foo' USING euc_kr_to_utf8); |
| SELECT CONVERT('foo', 'EUC_KR', 'UTF8'); |
| -- UTF8 --> EUC_KR |
| SELECT CONVERT('foo' USING utf8_to_euc_kr); |
| SELECT CONVERT('foo', 'UTF8', 'EUC_KR'); |
| -- EUC_TW --> UTF8 |
| SELECT CONVERT('foo' USING euc_tw_to_utf8); |
| SELECT CONVERT('foo', 'EUC_TW', 'UTF8'); |
| -- UTF8 --> EUC_TW |
| SELECT CONVERT('foo' USING utf8_to_euc_tw); |
| SELECT CONVERT('foo', 'UTF8', 'EUC_TW'); |
| -- GB18030 --> UTF8 |
| SELECT CONVERT('foo' USING gb18030_to_utf8); |
| SELECT CONVERT('foo', 'GB18030', 'UTF8'); |
| -- UTF8 --> GB18030 |
| SELECT CONVERT('foo' USING utf8_to_gb18030); |
| SELECT CONVERT('foo', 'UTF8', 'GB18030'); |
| -- GBK --> UTF8 |
| SELECT CONVERT('foo' USING gbk_to_utf8); |
| SELECT CONVERT('foo', 'GBK', 'UTF8'); |
| -- UTF8 --> GBK |
| SELECT CONVERT('foo' USING utf8_to_gbk); |
| SELECT CONVERT('foo', 'UTF8', 'GBK'); |
| -- UTF8 --> LATIN2 |
| SELECT CONVERT('foo' USING utf8_to_iso_8859_2); |
| SELECT CONVERT('foo', 'UTF8', 'LATIN2'); |
| -- LATIN2 --> UTF8 |
| SELECT CONVERT('foo' USING iso_8859_2_to_utf8); |
| SELECT CONVERT('foo', 'LATIN2', 'UTF8'); |
| -- UTF8 --> LATIN3 |
| SELECT CONVERT('foo' USING utf8_to_iso_8859_3); |
| SELECT CONVERT('foo', 'UTF8', 'LATIN3'); |
| -- LATIN3 --> UTF8 |
| SELECT CONVERT('foo' USING iso_8859_3_to_utf8); |
| SELECT CONVERT('foo', 'LATIN3', 'UTF8'); |
| -- UTF8 --> LATIN4 |
| SELECT CONVERT('foo' USING utf8_to_iso_8859_4); |
| SELECT CONVERT('foo', 'UTF8', 'LATIN4'); |
| -- LATIN4 --> UTF8 |
| SELECT CONVERT('foo' USING iso_8859_4_to_utf8); |
| SELECT CONVERT('foo', 'LATIN4', 'UTF8'); |
| -- UTF8 --> LATIN5 |
| SELECT CONVERT('foo' USING utf8_to_iso_8859_9); |
| SELECT CONVERT('foo', 'UTF8', 'LATIN5'); |
| -- LATIN5 --> UTF8 |
| SELECT CONVERT('foo' USING iso_8859_9_to_utf8); |
| SELECT CONVERT('foo', 'LATIN5', 'UTF8'); |
| -- UTF8 --> LATIN6 |
| SELECT CONVERT('foo' USING utf8_to_iso_8859_10); |
| SELECT CONVERT('foo', 'UTF8', 'LATIN6'); |
| -- LATIN6 --> UTF8 |
| SELECT CONVERT('foo' USING iso_8859_10_to_utf8); |
| SELECT CONVERT('foo', 'LATIN6', 'UTF8'); |
| -- UTF8 --> LATIN7 |
| SELECT CONVERT('foo' USING utf8_to_iso_8859_13); |
| SELECT CONVERT('foo', 'UTF8', 'LATIN7'); |
| -- LATIN7 --> UTF8 |
| SELECT CONVERT('foo' USING iso_8859_13_to_utf8); |
| SELECT CONVERT('foo', 'LATIN7', 'UTF8'); |
| -- UTF8 --> LATIN8 |
| SELECT CONVERT('foo' USING utf8_to_iso_8859_14); |
| SELECT CONVERT('foo', 'UTF8', 'LATIN8'); |
| -- LATIN8 --> UTF8 |
| SELECT CONVERT('foo' USING iso_8859_14_to_utf8); |
| SELECT CONVERT('foo', 'LATIN8', 'UTF8'); |
| -- UTF8 --> LATIN9 |
| SELECT CONVERT('foo' USING utf8_to_iso_8859_15); |
| SELECT CONVERT('foo', 'UTF8', 'LATIN9'); |
| -- LATIN9 --> UTF8 |
| SELECT CONVERT('foo' USING iso_8859_15_to_utf8); |
| SELECT CONVERT('foo', 'LATIN9', 'UTF8'); |
| -- UTF8 --> LATIN10 |
| SELECT CONVERT('foo' USING utf8_to_iso_8859_16); |
| SELECT CONVERT('foo', 'UTF8', 'LATIN10'); |
| -- LATIN10 --> UTF8 |
| SELECT CONVERT('foo' USING iso_8859_16_to_utf8); |
| SELECT CONVERT('foo', 'LATIN10', 'UTF8'); |
| -- UTF8 --> ISO-8859-5 |
| SELECT CONVERT('foo' USING utf8_to_iso_8859_5); |
| SELECT CONVERT('foo', 'UTF8', 'ISO-8859-5'); |
| -- ISO-8859-5 --> UTF8 |
| SELECT CONVERT('foo' USING iso_8859_5_to_utf8); |
| SELECT CONVERT('foo', 'ISO-8859-5', 'UTF8'); |
| -- UTF8 --> ISO-8859-6 |
| SELECT CONVERT('foo' USING utf8_to_iso_8859_6); |
| SELECT CONVERT('foo', 'UTF8', 'ISO-8859-6'); |
| -- ISO-8859-6 --> UTF8 |
| SELECT CONVERT('foo' USING iso_8859_6_to_utf8); |
| SELECT CONVERT('foo', 'ISO-8859-6', 'UTF8'); |
| -- UTF8 --> ISO-8859-7 |
| SELECT CONVERT('foo' USING utf8_to_iso_8859_7); |
| SELECT CONVERT('foo', 'UTF8', 'ISO-8859-7'); |
| -- ISO-8859-7 --> UTF8 |
| SELECT CONVERT('foo' USING iso_8859_7_to_utf8); |
| SELECT CONVERT('foo', 'ISO-8859-7', 'UTF8'); |
| -- UTF8 --> ISO-8859-8 |
| SELECT CONVERT('foo' USING utf8_to_iso_8859_8); |
| SELECT CONVERT('foo', 'UTF8', 'ISO-8859-8'); |
| -- ISO-8859-8 --> UTF8 |
| SELECT CONVERT('foo' USING iso_8859_8_to_utf8); |
| SELECT CONVERT('foo', 'ISO-8859-8', 'UTF8'); |
| -- LATIN1 --> UTF8 |
| SELECT CONVERT('foo' USING iso_8859_1_to_utf8); |
| SELECT CONVERT('foo', 'LATIN1', 'UTF8'); |
| -- UTF8 --> LATIN1 |
| SELECT CONVERT('foo' USING utf8_to_iso_8859_1); |
| SELECT CONVERT('foo', 'UTF8', 'LATIN1'); |
| -- JOHAB --> UTF8 |
| SELECT CONVERT('foo' USING johab_to_utf8); |
| SELECT CONVERT('foo', 'JOHAB', 'UTF8'); |
| -- UTF8 --> JOHAB |
| SELECT CONVERT('foo' USING utf8_to_johab); |
| SELECT CONVERT('foo', 'UTF8', 'JOHAB'); |
| -- SJIS --> UTF8 |
| SELECT CONVERT('foo' USING sjis_to_utf8); |
| SELECT CONVERT('foo', 'SJIS', 'UTF8'); |
| -- UTF8 --> SJIS |
| SELECT CONVERT('foo' USING utf8_to_sjis); |
| SELECT CONVERT('foo', 'UTF8', 'SJIS'); |
| -- WIN1258 --> UTF8 |
| SELECT CONVERT('foo' USING windows_1258_to_utf8); |
| SELECT CONVERT('foo', 'WIN1258', 'UTF8'); |
| -- UTF8 --> WIN1258 |
| SELECT CONVERT('foo' USING utf8_to_windows_1258); |
| SELECT CONVERT('foo', 'UTF8', 'WIN1258'); |
| -- UHC --> UTF8 |
| SELECT CONVERT('foo' USING uhc_to_utf8); |
| SELECT CONVERT('foo', 'UHC', 'UTF8'); |
| -- UTF8 --> UHC |
| SELECT CONVERT('foo' USING utf8_to_uhc); |
| SELECT CONVERT('foo', 'UTF8', 'UHC'); |
| -- UTF8 --> WIN1250 |
| SELECT CONVERT('foo' USING utf8_to_windows_1250); |
| SELECT CONVERT('foo', 'UTF8', 'WIN1250'); |
| -- WIN1250 --> UTF8 |
| SELECT CONVERT('foo' USING windows_1250_to_utf8); |
| SELECT CONVERT('foo', 'WIN1250', 'UTF8'); |
| -- UTF8 --> WIN1256 |
| SELECT CONVERT('foo' USING utf8_to_windows_1256); |
| SELECT CONVERT('foo', 'UTF8', 'WIN1256'); |
| -- WIN1256 --> UTF8 |
| SELECT CONVERT('foo' USING windows_1256_to_utf8); |
| SELECT CONVERT('foo', 'WIN1256', 'UTF8'); |
| -- UTF8 --> WIN874 |
| SELECT CONVERT('foo' USING utf8_to_windows_874); |
| SELECT CONVERT('foo', 'UTF8', 'WIN874'); |
| -- WIN874 --> UTF8 |
| SELECT CONVERT('foo' USING windows_874_to_utf8); |
| SELECT CONVERT('foo', 'WIN874', 'UTF8'); |
| -- UTF8 --> WIN1253 |
| SELECT CONVERT('foo' USING utf8_to_windows_1253); |
| SELECT CONVERT('foo', 'UTF8', 'WIN1253'); |
| -- WIN1253 --> UTF8 |
| SELECT CONVERT('foo' USING windows_1253_to_utf8); |
| SELECT CONVERT('foo', 'WIN1253', 'UTF8'); |
| -- UTF8 --> WIN1254 |
| SELECT CONVERT('foo' USING utf8_to_windows_1254); |
| SELECT CONVERT('foo', 'UTF8', 'WIN1254'); |
| -- WIN1254 --> UTF8 |
| SELECT CONVERT('foo' USING windows_1254_to_utf8); |
| SELECT CONVERT('foo', 'WIN1254', 'UTF8'); |
| -- UTF8 --> WIN1255 |
| SELECT CONVERT('foo' USING utf8_to_windows_1255); |
| SELECT CONVERT('foo', 'UTF8', 'WIN1255'); |
| -- WIN1255 --> UTF8 |
| SELECT CONVERT('foo' USING windows_1255_to_utf8); |
| SELECT CONVERT('foo', 'WIN1255', 'UTF8'); |
| -- UTF8 --> WIN1257 |
| SELECT CONVERT('foo' USING utf8_to_windows_1257); |
| SELECT CONVERT('foo', 'UTF8', 'WIN1257'); |
| -- WIN1257 --> UTF8 |
| SELECT CONVERT('foo' USING windows_1257_to_utf8); |
| SELECT CONVERT('foo', 'WIN1257', 'UTF8'); |
| -- |
| -- return to the super user |
| -- |
| RESET SESSION AUTHORIZATION; |
| DROP USER conversion_test_user; |