Remove "convert 'blah' using conversion_name" facility, because if it

produces text it is an encoding hole and if not it's incompatible
with the spec, whatever the spec means (which we're not sure about anyway).

7 files changed, 6 insertions, 1022 deletions

diff --git a/src/backend/catalog/pg_conversion.c b/src/backend/catalog/pg_conversion.c
index 7146d0b4f53..e9c75ebdb60 100644
--- a/src/backend/catalog/pg_conversion.c
+++ b/src/backend/catalog/pg_conversion.c
@@ -8,7 +8,7 @@
  *
  *
  * IDENTIFICATION
- *	  $PostgreSQL: pgsql/src/backend/catalog/pg_conversion.c,v 1.37 2007/09/18 17:41:17 adunstan Exp $
+ *	  $PostgreSQL: pgsql/src/backend/catalog/pg_conversion.c,v 1.38 2007/09/24 01:29:28 adunstan Exp $
  *
  *-------------------------------------------------------------------------
  */
@@ -276,76 +276,3 @@ FindConversion(const char *conname, Oid connamespace)
 	return conoid;
 }
 
-/*
- * Execute SQL99's CONVERT function.
- *
- * CONVERT <left paren> <character value expression>
- * USING <form-of-use conversion name> <right paren>
- *
- * BYTEA convert_using(TEXT string, TEXT conversion_name)
- *
- * bytea is returned so we don't give a value that is
- * not valid in the database encoding.
- */
-Datum
-pg_convert_using(PG_FUNCTION_ARGS)
-{
-	text	   *string = PG_GETARG_TEXT_P(0);
-	text	   *conv_name = PG_GETARG_TEXT_P(1);
-	text	   *retval;
-	List	   *parsed_name;
-	Oid			convoid;
-	HeapTuple	tuple;
-	Form_pg_conversion body;
-	char	   *str;
-	char	   *result;
-	int			len;
-
-	/* Convert input string to null-terminated form */
-	len = VARSIZE(string) - VARHDRSZ;
-	str = palloc(len + 1);
-	memcpy(str, VARDATA(string), len);
-	*(str + len) = '\0';
-
-	/* Look up the conversion name */
-	parsed_name = textToQualifiedNameList(conv_name);
-	convoid = FindConversionByName(parsed_name);
-	if (!OidIsValid(convoid))
-		ereport(ERROR,
-				(errcode(ERRCODE_UNDEFINED_OBJECT),
-				 errmsg("conversion \"%s\" does not exist",
-						NameListToString(parsed_name))));
-
-	tuple = SearchSysCache(CONVOID,
-						   ObjectIdGetDatum(convoid),
-						   0, 0, 0);
-	if (!HeapTupleIsValid(tuple))
-		elog(ERROR, "cache lookup failed for conversion %u", convoid);
-	body = (Form_pg_conversion) GETSTRUCT(tuple);
-
-	/* Temporary result area should be more than big enough */
-	result = palloc(len * 4 + 1);
-
-	OidFunctionCall5(body->conproc,
-					 Int32GetDatum(body->conforencoding),
-					 Int32GetDatum(body->contoencoding),
-					 CStringGetDatum(str),
-					 CStringGetDatum(result),
-					 Int32GetDatum(len));
-
-	ReleaseSysCache(tuple);
-
-	/*
-	 * build text result structure. we cannot use textin() here, since textin
-	 * assumes that input string encoding is same as database encoding.
-	 */
-	len = strlen(result) + VARHDRSZ;
-	retval = palloc(len);
-	SET_VARSIZE(retval, len);
-	memcpy(VARDATA(retval), result, len - VARHDRSZ);
-
-	pfree(result);
-	pfree(str);
-
-	PG_RETURN_BYTEA_P(retval);
-}
diff --git a/src/backend/parser/gram.y b/src/backend/parser/gram.y
index a7521eca522..1452fe7ff2b 100644
--- a/src/backend/parser/gram.y
+++ b/src/backend/parser/gram.y
@@ -11,7 +11,7 @@
  *
  *
  * IDENTIFICATION
- *	  $PostgreSQL: pgsql/src/backend/parser/gram.y,v 2.602 2007/09/03 18:46:30 tgl Exp $
+ *	  $PostgreSQL: pgsql/src/backend/parser/gram.y,v 2.603 2007/09/24 01:29:28 adunstan Exp $
  *
  * HISTORY
  *	  AUTHOR			DATE			MAJOR EVENT
@@ -377,7 +377,7 @@ static Node *makeXmlExpr(XmlExprOp op, char *name, List *named_args, List *args)
 	CHARACTER CHARACTERISTICS CHECK CHECKPOINT CLASS CLOSE
 	CLUSTER COALESCE COLLATE COLUMN COMMENT COMMIT
 	COMMITTED CONCURRENTLY CONFIGURATION CONNECTION CONSTRAINT CONSTRAINTS
-	CONTENT_P CONVERSION_P CONVERT COPY COST CREATE CREATEDB
+	CONTENT_P CONVERSION_P COPY COST CREATE CREATEDB
 	CREATEROLE CREATEUSER CROSS CSV CURRENT_P CURRENT_DATE CURRENT_ROLE
 	CURRENT_TIME CURRENT_TIMESTAMP CURRENT_USER CURSOR CYCLE
 
@@ -8218,31 +8218,6 @@ func_expr:	func_name '(' ')'
 					n->location = @1;
 					$$ = (Node *)n;
 				}
-			| CONVERT '(' a_expr USING any_name ')'
-				{
-					FuncCall *n = makeNode(FuncCall);
-					A_Const *c = makeNode(A_Const);
-
-					c->val.type = T_String;
-					c->val.val.str = NameListToQuotedString($5);
-
-					n->funcname = SystemFuncName("convert_using");
-					n->args = list_make2($3, c);
-					n->agg_star = FALSE;
-					n->agg_distinct = FALSE;
-					n->location = @1;
-					$$ = (Node *)n;
-				}
-			| CONVERT '(' expr_list ')'
-				{
-					FuncCall *n = makeNode(FuncCall);
-					n->funcname = SystemFuncName("convert");
-					n->args = $3;
-					n->agg_star = FALSE;
-					n->agg_distinct = FALSE;
-					n->location = @1;
-					$$ = (Node *)n;
-				}
 			| NULLIF '(' a_expr ',' a_expr ')'
 				{
 					$$ = (Node *) makeSimpleA_Expr(AEXPR_NULLIF, "=", $3, $5, @1);
@@ -9291,7 +9266,6 @@ col_name_keyword:
 			| CHAR_P
 			| CHARACTER
 			| COALESCE
-			| CONVERT
 			| DEC
 			| DECIMAL_P
 			| EXISTS
diff --git a/src/backend/parser/keywords.c b/src/backend/parser/keywords.c
index dcebad392c8..473ba15252e 100644
--- a/src/backend/parser/keywords.c
+++ b/src/backend/parser/keywords.c
@@ -8,7 +8,7 @@
  *
  *
  * IDENTIFICATION
- *	  $PostgreSQL: pgsql/src/backend/parser/keywords.c,v 1.191 2007/08/21 15:13:42 tgl Exp $
+ *	  $PostgreSQL: pgsql/src/backend/parser/keywords.c,v 1.192 2007/09/24 01:29:29 adunstan Exp $
  *
  *-------------------------------------------------------------------------
  */
@@ -93,7 +93,6 @@ static const ScanKeyword ScanKeywords[] = {
 	{"constraints", CONSTRAINTS, UNRESERVED_KEYWORD},
 	{"content", CONTENT_P, UNRESERVED_KEYWORD},
 	{"conversion", CONVERSION_P, UNRESERVED_KEYWORD},
-	{"convert", CONVERT, COL_NAME_KEYWORD},
 	{"copy", COPY, UNRESERVED_KEYWORD},
 	{"cost", COST, UNRESERVED_KEYWORD},
 	{"create", CREATE, RESERVED_KEYWORD},
diff --git a/src/include/catalog/pg_proc.h b/src/include/catalog/pg_proc.h
index 3eaead16bda..6dba4dbc39d 100644
--- a/src/include/catalog/pg_proc.h
+++ b/src/include/catalog/pg_proc.h
@@ -7,7 +7,7 @@
  * Portions Copyright (c) 1996-2007, PostgreSQL Global Development Group
  * Portions Copyright (c) 1994, Regents of the University of California
  *
- * $PostgreSQL: pgsql/src/include/catalog/pg_proc.h,v 1.471 2007/09/20 17:56:32 tgl Exp $
+ * $PostgreSQL: pgsql/src/include/catalog/pg_proc.h,v 1.472 2007/09/24 01:29:29 adunstan Exp $
  *
  * NOTES
  *	  The script catalog/genbki.sh reads this file and generates .bki
@@ -2244,9 +2244,6 @@ DESCR("convert string with specified destination encoding name");
 DATA(insert OID = 1813 (  convert		   PGNSP PGUID 12 1 0 f f t f s 3 17 "17 19 19" _null_ _null_ _null_ pg_convert - _null_ _null_ ));
 DESCR("convert string with specified encoding names");
 
-DATA(insert OID = 1619 (  convert_using    PGNSP PGUID 12 1 0 f f t f s 2 17 "25 25" _null_ _null_ _null_ pg_convert_using - _null_ _null_ ));
-DESCR("convert string with specified conversion name");
-
 DATA(insert OID = 1264 (  pg_char_to_encoding	   PGNSP PGUID 12 1 0 f f t f s 1 23 "19" _null_ _null_ _null_	PG_char_to_encoding - _null_ _null_ ));
 DESCR("convert encoding name to encoding id");
 
diff --git a/src/include/utils/builtins.h b/src/include/utils/builtins.h
index c1610f320f5..d1b11a5e625 100644
--- a/src/include/utils/builtins.h
+++ b/src/include/utils/builtins.h
@@ -7,7 +7,7 @@
  * Portions Copyright (c) 1996-2007, PostgreSQL Global Development Group
  * Portions Copyright (c) 1994, Regents of the University of California
  *
- * $PostgreSQL: pgsql/src/include/utils/builtins.h,v 1.303 2007/09/18 17:41:17 adunstan Exp $
+ * $PostgreSQL: pgsql/src/include/utils/builtins.h,v 1.304 2007/09/24 01:29:30 adunstan Exp $
  *
  *-------------------------------------------------------------------------
  */
@@ -941,9 +941,6 @@ extern Datum pg_advisory_unlock_all(PG_FUNCTION_ARGS);
 /* access/transam/twophase.c */
 extern Datum pg_prepared_xact(PG_FUNCTION_ARGS);
 
-/* catalog/pg_conversion.c */
-extern Datum pg_convert_using(PG_FUNCTION_ARGS);
-
 /* commands/prepare.c */
 extern Datum pg_prepared_statement(PG_FUNCTION_ARGS);
 
diff --git a/src/test/regress/expected/conversion.out b/src/test/regress/expected/conversion.out
index cd3f0e2c48d..e80e1a45343 100644
--- a/src/test/regress/expected/conversion.out
+++ b/src/test/regress/expected/conversion.out
@@ -31,12 +31,6 @@ 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 
 ---------
@@ -44,12 +38,6 @@ SELECT CONVERT('foo', 'SQL_ASCII', 'MULE_INTERNAL');
 (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 
 ---------
@@ -57,12 +45,6 @@ SELECT CONVERT('foo', 'MULE_INTERNAL', 'SQL_ASCII');
 (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 
 ---------
@@ -70,12 +52,6 @@ SELECT CONVERT('foo', 'KOI8R', 'MULE_INTERNAL');
 (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 
 ---------
@@ -83,12 +59,6 @@ SELECT CONVERT('foo', 'MULE_INTERNAL', 'KOI8R');
 (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 
 ---------
@@ -96,12 +66,6 @@ SELECT CONVERT('foo', 'ISO-8859-5', 'MULE_INTERNAL');
 (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 
 ---------
@@ -109,12 +73,6 @@ SELECT CONVERT('foo', 'MULE_INTERNAL', 'ISO-8859-5');
 (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 
 ---------
@@ -122,12 +80,6 @@ SELECT CONVERT('foo', 'WIN1251', 'MULE_INTERNAL');
 (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 
 ---------
@@ -135,12 +87,6 @@ SELECT CONVERT('foo', 'MULE_INTERNAL', 'WIN1251');
 (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 
 ---------
@@ -148,12 +94,6 @@ SELECT CONVERT('foo', 'WIN866', 'MULE_INTERNAL');
 (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 
 ---------
@@ -161,12 +101,6 @@ SELECT CONVERT('foo', 'MULE_INTERNAL', 'WIN866');
 (1 row)
 
 -- KOI8R --> WIN1251
-SELECT CONVERT('foo' USING koi8_r_to_windows_1251);
- convert_using 
----------------
- foo
-(1 row)
-
 SELECT CONVERT('foo', 'KOI8R', 'WIN1251');
  convert 
 ---------
@@ -174,12 +108,6 @@ SELECT CONVERT('foo', 'KOI8R', 'WIN1251');
 (1 row)
 
 -- WIN1251 --> KOI8R
-SELECT CONVERT('foo' USING windows_1251_to_koi8_r);
- convert_using 
----------------
- foo
-(1 row)
-
 SELECT CONVERT('foo', 'WIN1251', 'KOI8R');
  convert 
 ---------
@@ -187,12 +115,6 @@ SELECT CONVERT('foo', 'WIN1251', 'KOI8R');
 (1 row)
 
 -- KOI8R --> WIN866
-SELECT CONVERT('foo' USING koi8_r_to_windows_866);
- convert_using 
----------------
- foo
-(1 row)
-
 SELECT CONVERT('foo', 'KOI8R', 'WIN866');
  convert 
 ---------
@@ -200,12 +122,6 @@ SELECT CONVERT('foo', 'KOI8R', 'WIN866');
 (1 row)
 
 -- WIN866 --> KOI8R
-SELECT CONVERT('foo' USING windows_866_to_koi8_r);
- convert_using 
----------------
- foo
-(1 row)
-
 SELECT CONVERT('foo', 'WIN866', 'KOI8R');
  convert 
 ---------
@@ -213,12 +129,6 @@ SELECT CONVERT('foo', 'WIN866', 'KOI8R');
 (1 row)
 
 -- WIN866 --> WIN1251
-SELECT CONVERT('foo' USING windows_866_to_windows_1251);
- convert_using 
----------------
- foo
-(1 row)
-
 SELECT CONVERT('foo', 'WIN866', 'WIN1251');
  convert 
 ---------
@@ -226,12 +136,6 @@ SELECT CONVERT('foo', 'WIN866', 'WIN1251');
 (1 row)
 
 -- WIN1251 --> WIN866
-SELECT CONVERT('foo' USING windows_1251_to_windows_866);
- convert_using 
----------------
- foo
-(1 row)
-
 SELECT CONVERT('foo', 'WIN1251', 'WIN866');
  convert 
 ---------
@@ -239,12 +143,6 @@ SELECT CONVERT('foo', 'WIN1251', 'WIN866');
 (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 
 ---------
@@ -252,12 +150,6 @@ SELECT CONVERT('foo', 'ISO-8859-5', 'KOI8R');
 (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 
 ---------
@@ -265,12 +157,6 @@ SELECT CONVERT('foo', 'KOI8R', 'ISO-8859-5');
 (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 
 ---------
@@ -278,12 +164,6 @@ SELECT CONVERT('foo', 'ISO-8859-5', 'WIN1251');
 (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 
 ---------
@@ -291,12 +171,6 @@ SELECT CONVERT('foo', 'WIN1251', 'ISO-8859-5');
 (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 
 ---------
@@ -304,12 +178,6 @@ SELECT CONVERT('foo', 'ISO-8859-5', 'WIN866');
 (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 
 ---------
@@ -317,12 +185,6 @@ SELECT CONVERT('foo', 'WIN866', 'ISO-8859-5');
 (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 
 ---------
@@ -330,12 +192,6 @@ SELECT CONVERT('foo', 'EUC_CN', 'MULE_INTERNAL');
 (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 
 ---------
@@ -343,12 +199,6 @@ SELECT CONVERT('foo', 'MULE_INTERNAL', 'EUC_CN');
 (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 
 ---------
@@ -356,12 +206,6 @@ SELECT CONVERT('foo', 'EUC_JP', 'SJIS');
 (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 
 ---------
@@ -369,12 +213,6 @@ SELECT CONVERT('foo', 'SJIS', 'EUC_JP');
 (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 
 ---------
@@ -382,12 +220,6 @@ SELECT CONVERT('foo', 'EUC_JP', 'MULE_INTERNAL');
 (1 row)
 
 -- SJIS --> MULE_INTERNAL
-SELECT CONVERT('foo' USING sjis_to_mic);
- convert_using 
----------------
- foo
-(1 row)
-
 SELECT CONVERT('foo', 'SJIS', 'MULE_INTERNAL');
  convert 
 ---------
@@ -395,12 +227,6 @@ SELECT CONVERT('foo', 'SJIS', 'MULE_INTERNAL');
 (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 
 ---------
@@ -408,12 +234,6 @@ SELECT CONVERT('foo', 'MULE_INTERNAL', 'EUC_JP');
 (1 row)
 
 -- MULE_INTERNAL --> SJIS
-SELECT CONVERT('foo' USING mic_to_sjis);
- convert_using 
----------------
- foo
-(1 row)
-
 SELECT CONVERT('foo', 'MULE_INTERNAL', 'SJIS');
  convert 
 ---------
@@ -421,12 +241,6 @@ SELECT CONVERT('foo', 'MULE_INTERNAL', 'SJIS');
 (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 
 ---------
@@ -434,12 +248,6 @@ SELECT CONVERT('foo', 'EUC_KR', 'MULE_INTERNAL');
 (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 
 ---------
@@ -447,12 +255,6 @@ SELECT CONVERT('foo', 'MULE_INTERNAL', 'EUC_KR');
 (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 
 ---------
@@ -460,12 +262,6 @@ SELECT CONVERT('foo', 'EUC_TW', 'BIG5');
 (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 
 ---------
@@ -473,12 +269,6 @@ SELECT CONVERT('foo', 'BIG5', 'EUC_TW');
 (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 
 ---------
@@ -486,12 +276,6 @@ SELECT CONVERT('foo', 'EUC_TW', 'MULE_INTERNAL');
 (1 row)
 
 -- BIG5 --> MULE_INTERNAL
-SELECT CONVERT('foo' USING big5_to_mic);
- convert_using 
----------------
- foo
-(1 row)
-
 SELECT CONVERT('foo', 'BIG5', 'MULE_INTERNAL');
  convert 
 ---------
@@ -499,12 +283,6 @@ SELECT CONVERT('foo', 'BIG5', 'MULE_INTERNAL');
 (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 
 ---------
@@ -512,12 +290,6 @@ SELECT CONVERT('foo', 'MULE_INTERNAL', 'EUC_TW');
 (1 row)
 
 -- MULE_INTERNAL --> BIG5
-SELECT CONVERT('foo' USING mic_to_big5);
- convert_using 
----------------
- foo
-(1 row)
-
 SELECT CONVERT('foo', 'MULE_INTERNAL', 'BIG5');
  convert 
 ---------
@@ -525,12 +297,6 @@ SELECT CONVERT('foo', 'MULE_INTERNAL', 'BIG5');
 (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 
 ---------
@@ -538,12 +304,6 @@ SELECT CONVERT('foo', 'LATIN2', 'MULE_INTERNAL');
 (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 
 ---------
@@ -551,12 +311,6 @@ SELECT CONVERT('foo', 'MULE_INTERNAL', 'LATIN2');
 (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 
 ---------
@@ -564,12 +318,6 @@ SELECT CONVERT('foo', 'WIN1250', 'MULE_INTERNAL');
 (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 
 ---------
@@ -577,12 +325,6 @@ SELECT CONVERT('foo', 'MULE_INTERNAL', 'WIN1250');
 (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 
 ---------
@@ -590,12 +332,6 @@ SELECT CONVERT('foo', 'LATIN2', 'WIN1250');
 (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 
 ---------
@@ -603,12 +339,6 @@ SELECT CONVERT('foo', 'WIN1250', 'LATIN2');
 (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 
 ---------
@@ -616,12 +346,6 @@ SELECT CONVERT('foo', 'LATIN1', 'MULE_INTERNAL');
 (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 
 ---------
@@ -629,12 +353,6 @@ SELECT CONVERT('foo', 'MULE_INTERNAL', 'LATIN1');
 (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 
 ---------
@@ -642,12 +360,6 @@ SELECT CONVERT('foo', 'LATIN3', 'MULE_INTERNAL');
 (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 
 ---------
@@ -655,12 +367,6 @@ SELECT CONVERT('foo', 'MULE_INTERNAL', 'LATIN3');
 (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 
 ---------
@@ -668,12 +374,6 @@ SELECT CONVERT('foo', 'LATIN4', 'MULE_INTERNAL');
 (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 
 ---------
@@ -681,12 +381,6 @@ SELECT CONVERT('foo', 'MULE_INTERNAL', 'LATIN4');
 (1 row)
 
 -- SQL_ASCII --> UTF8
-SELECT CONVERT('foo' USING ascii_to_utf8);
- convert_using 
----------------
- foo
-(1 row)
-
 SELECT CONVERT('foo', 'SQL_ASCII', 'UTF8');
  convert 
 ---------
@@ -694,12 +388,6 @@ SELECT CONVERT('foo', 'SQL_ASCII', 'UTF8');
 (1 row)
 
 -- UTF8 --> SQL_ASCII
-SELECT CONVERT('foo' USING utf8_to_ascii);
- convert_using 
----------------
- foo
-(1 row)
-
 SELECT CONVERT('foo', 'UTF8', 'SQL_ASCII');
  convert 
 ---------
@@ -707,12 +395,6 @@ SELECT CONVERT('foo', 'UTF8', 'SQL_ASCII');
 (1 row)
 
 -- BIG5 --> UTF8
-SELECT CONVERT('foo' USING big5_to_utf8);
- convert_using 
----------------
- foo
-(1 row)
-
 SELECT CONVERT('foo', 'BIG5', 'UTF8');
  convert 
 ---------
@@ -720,12 +402,6 @@ SELECT CONVERT('foo', 'BIG5', 'UTF8');
 (1 row)
 
 -- UTF8 --> BIG5
-SELECT CONVERT('foo' USING utf8_to_big5);
- convert_using 
----------------
- foo
-(1 row)
-
 SELECT CONVERT('foo', 'UTF8', 'BIG5');
  convert 
 ---------
@@ -733,12 +409,6 @@ SELECT CONVERT('foo', 'UTF8', 'BIG5');
 (1 row)
 
 -- UTF8 --> KOI8R
-SELECT CONVERT('foo' USING utf8_to_koi8_r);
- convert_using 
----------------
- foo
-(1 row)
-
 SELECT CONVERT('foo', 'UTF8', 'KOI8R');
  convert 
 ---------
@@ -746,12 +416,6 @@ SELECT CONVERT('foo', 'UTF8', 'KOI8R');
 (1 row)
 
 -- KOI8R --> UTF8
-SELECT CONVERT('foo' USING koi8_r_to_utf8);
- convert_using 
----------------
- foo
-(1 row)
-
 SELECT CONVERT('foo', 'KOI8R', 'UTF8');
  convert 
 ---------
@@ -759,12 +423,6 @@ SELECT CONVERT('foo', 'KOI8R', 'UTF8');
 (1 row)
 
 -- UTF8 --> WIN1251
-SELECT CONVERT('foo' USING utf8_to_windows_1251);
- convert_using 
----------------
- foo
-(1 row)
-
 SELECT CONVERT('foo', 'UTF8', 'WIN1251');
  convert 
 ---------
@@ -772,12 +430,6 @@ SELECT CONVERT('foo', 'UTF8', 'WIN1251');
 (1 row)
 
 -- WIN1251 --> UTF8
-SELECT CONVERT('foo' USING windows_1251_to_utf8);
- convert_using 
----------------
- foo
-(1 row)
-
 SELECT CONVERT('foo', 'WIN1251', 'UTF8');
  convert 
 ---------
@@ -785,12 +437,6 @@ SELECT CONVERT('foo', 'WIN1251', 'UTF8');
 (1 row)
 
 -- UTF8 --> WIN1252
-SELECT CONVERT('foo' USING utf8_to_windows_1252);
- convert_using 
----------------
- foo
-(1 row)
-
 SELECT CONVERT('foo', 'UTF8', 'WIN1252');
  convert 
 ---------
@@ -798,12 +444,6 @@ SELECT CONVERT('foo', 'UTF8', 'WIN1252');
 (1 row)
 
 -- WIN1252 --> UTF8
-SELECT CONVERT('foo' USING windows_1252_to_utf8);
- convert_using 
----------------
- foo
-(1 row)
-
 SELECT CONVERT('foo', 'WIN1252', 'UTF8');
  convert 
 ---------
@@ -811,12 +451,6 @@ SELECT CONVERT('foo', 'WIN1252', 'UTF8');
 (1 row)
 
 -- UTF8 --> WIN866
-SELECT CONVERT('foo' USING utf8_to_windows_866);
- convert_using 
----------------
- foo
-(1 row)
-
 SELECT CONVERT('foo', 'UTF8', 'WIN866');
  convert 
 ---------
@@ -824,12 +458,6 @@ SELECT CONVERT('foo', 'UTF8', 'WIN866');
 (1 row)
 
 -- WIN866 --> UTF8
-SELECT CONVERT('foo' USING windows_866_to_utf8);
- convert_using 
----------------
- foo
-(1 row)
-
 SELECT CONVERT('foo', 'WIN866', 'UTF8');
  convert 
 ---------
@@ -837,12 +465,6 @@ SELECT CONVERT('foo', 'WIN866', 'UTF8');
 (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 
 ---------
@@ -850,12 +472,6 @@ SELECT CONVERT('foo', 'EUC_CN', 'UTF8');
 (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 
 ---------
@@ -863,12 +479,6 @@ SELECT CONVERT('foo', 'UTF8', 'EUC_CN');
 (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 
 ---------
@@ -876,12 +486,6 @@ SELECT CONVERT('foo', 'EUC_JP', 'UTF8');
 (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 
 ---------
@@ -889,12 +493,6 @@ SELECT CONVERT('foo', 'UTF8', 'EUC_JP');
 (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 
 ---------
@@ -902,12 +500,6 @@ SELECT CONVERT('foo', 'EUC_KR', 'UTF8');
 (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 
 ---------
@@ -915,12 +507,6 @@ SELECT CONVERT('foo', 'UTF8', 'EUC_KR');
 (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 
 ---------
@@ -928,12 +514,6 @@ SELECT CONVERT('foo', 'EUC_TW', 'UTF8');
 (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 
 ---------
@@ -941,12 +521,6 @@ SELECT CONVERT('foo', 'UTF8', 'EUC_TW');
 (1 row)
 
 -- GB18030 --> UTF8
-SELECT CONVERT('foo' USING gb18030_to_utf8);
- convert_using 
----------------
- foo
-(1 row)
-
 SELECT CONVERT('foo', 'GB18030', 'UTF8');
  convert 
 ---------
@@ -954,12 +528,6 @@ SELECT CONVERT('foo', 'GB18030', 'UTF8');
 (1 row)
 
 -- UTF8 --> GB18030
-SELECT CONVERT('foo' USING utf8_to_gb18030);
- convert_using 
----------------
- foo
-(1 row)
-
 SELECT CONVERT('foo', 'UTF8', 'GB18030');
  convert 
 ---------
@@ -967,12 +535,6 @@ SELECT CONVERT('foo', 'UTF8', 'GB18030');
 (1 row)
 
 -- GBK --> UTF8
-SELECT CONVERT('foo' USING gbk_to_utf8);
- convert_using 
----------------
- foo
-(1 row)
-
 SELECT CONVERT('foo', 'GBK', 'UTF8');
  convert 
 ---------
@@ -980,12 +542,6 @@ SELECT CONVERT('foo', 'GBK', 'UTF8');
 (1 row)
 
 -- UTF8 --> GBK
-SELECT CONVERT('foo' USING utf8_to_gbk);
- convert_using 
----------------
- foo
-(1 row)
-
 SELECT CONVERT('foo', 'UTF8', 'GBK');
  convert 
 ---------
@@ -993,12 +549,6 @@ SELECT CONVERT('foo', 'UTF8', 'GBK');
 (1 row)
 
 -- UTF8 --> LATIN2
-SELECT CONVERT('foo' USING utf8_to_iso_8859_2);
- convert_using 
----------------
- foo
-(1 row)
-
 SELECT CONVERT('foo', 'UTF8', 'LATIN2');
  convert 
 ---------
@@ -1006,12 +556,6 @@ SELECT CONVERT('foo', 'UTF8', 'LATIN2');
 (1 row)
 
 -- LATIN2 --> UTF8
-SELECT CONVERT('foo' USING iso_8859_2_to_utf8);
- convert_using 
----------------
- foo
-(1 row)
-
 SELECT CONVERT('foo', 'LATIN2', 'UTF8');
  convert 
 ---------
@@ -1019,12 +563,6 @@ SELECT CONVERT('foo', 'LATIN2', 'UTF8');
 (1 row)
 
 -- UTF8 --> LATIN3
-SELECT CONVERT('foo' USING utf8_to_iso_8859_3);
- convert_using 
----------------
- foo
-(1 row)
-
 SELECT CONVERT('foo', 'UTF8', 'LATIN3');
  convert 
 ---------
@@ -1032,12 +570,6 @@ SELECT CONVERT('foo', 'UTF8', 'LATIN3');
 (1 row)
 
 -- LATIN3 --> UTF8
-SELECT CONVERT('foo' USING iso_8859_3_to_utf8);
- convert_using 
----------------
- foo
-(1 row)
-
 SELECT CONVERT('foo', 'LATIN3', 'UTF8');
  convert 
 ---------
@@ -1045,12 +577,6 @@ SELECT CONVERT('foo', 'LATIN3', 'UTF8');
 (1 row)
 
 -- UTF8 --> LATIN4
-SELECT CONVERT('foo' USING utf8_to_iso_8859_4);
- convert_using 
----------------
- foo
-(1 row)
-
 SELECT CONVERT('foo', 'UTF8', 'LATIN4');
  convert 
 ---------
@@ -1058,12 +584,6 @@ SELECT CONVERT('foo', 'UTF8', 'LATIN4');
 (1 row)
 
 -- LATIN4 --> UTF8
-SELECT CONVERT('foo' USING iso_8859_4_to_utf8);
- convert_using 
----------------
- foo
-(1 row)
-
 SELECT CONVERT('foo', 'LATIN4', 'UTF8');
  convert 
 ---------
@@ -1071,12 +591,6 @@ SELECT CONVERT('foo', 'LATIN4', 'UTF8');
 (1 row)
 
 -- UTF8 --> LATIN5
-SELECT CONVERT('foo' USING utf8_to_iso_8859_9);
- convert_using 
----------------
- foo
-(1 row)
-
 SELECT CONVERT('foo', 'UTF8', 'LATIN5');
  convert 
 ---------
@@ -1084,12 +598,6 @@ SELECT CONVERT('foo', 'UTF8', 'LATIN5');
 (1 row)
 
 -- LATIN5 --> UTF8
-SELECT CONVERT('foo' USING iso_8859_9_to_utf8);
- convert_using 
----------------
- foo
-(1 row)
-
 SELECT CONVERT('foo', 'LATIN5', 'UTF8');
  convert 
 ---------
@@ -1097,12 +605,6 @@ SELECT CONVERT('foo', 'LATIN5', 'UTF8');
 (1 row)
 
 -- UTF8 --> LATIN6
-SELECT CONVERT('foo' USING utf8_to_iso_8859_10);
- convert_using 
----------------
- foo
-(1 row)
-
 SELECT CONVERT('foo', 'UTF8', 'LATIN6');
  convert 
 ---------
@@ -1110,12 +612,6 @@ SELECT CONVERT('foo', 'UTF8', 'LATIN6');
 (1 row)
 
 -- LATIN6 --> UTF8
-SELECT CONVERT('foo' USING iso_8859_10_to_utf8);
- convert_using 
----------------
- foo
-(1 row)
-
 SELECT CONVERT('foo', 'LATIN6', 'UTF8');
  convert 
 ---------
@@ -1123,12 +619,6 @@ SELECT CONVERT('foo', 'LATIN6', 'UTF8');
 (1 row)
 
 -- UTF8 --> LATIN7
-SELECT CONVERT('foo' USING utf8_to_iso_8859_13);
- convert_using 
----------------
- foo
-(1 row)
-
 SELECT CONVERT('foo', 'UTF8', 'LATIN7');
  convert 
 ---------
@@ -1136,12 +626,6 @@ SELECT CONVERT('foo', 'UTF8', 'LATIN7');
 (1 row)
 
 -- LATIN7 --> UTF8
-SELECT CONVERT('foo' USING iso_8859_13_to_utf8);
- convert_using 
----------------
- foo
-(1 row)
-
 SELECT CONVERT('foo', 'LATIN7', 'UTF8');
  convert 
 ---------
@@ -1149,12 +633,6 @@ SELECT CONVERT('foo', 'LATIN7', 'UTF8');
 (1 row)
 
 -- UTF8 --> LATIN8
-SELECT CONVERT('foo' USING utf8_to_iso_8859_14);
- convert_using 
----------------
- foo
-(1 row)
-
 SELECT CONVERT('foo', 'UTF8', 'LATIN8');
  convert 
 ---------
@@ -1162,12 +640,6 @@ SELECT CONVERT('foo', 'UTF8', 'LATIN8');
 (1 row)
 
 -- LATIN8 --> UTF8
-SELECT CONVERT('foo' USING iso_8859_14_to_utf8);
- convert_using 
----------------
- foo
-(1 row)
-
 SELECT CONVERT('foo', 'LATIN8', 'UTF8');
  convert 
 ---------
@@ -1175,12 +647,6 @@ SELECT CONVERT('foo', 'LATIN8', 'UTF8');
 (1 row)
 
 -- UTF8 --> LATIN9
-SELECT CONVERT('foo' USING utf8_to_iso_8859_15);
- convert_using 
----------------
- foo
-(1 row)
-
 SELECT CONVERT('foo', 'UTF8', 'LATIN9');
  convert 
 ---------
@@ -1188,12 +654,6 @@ SELECT CONVERT('foo', 'UTF8', 'LATIN9');
 (1 row)
 
 -- LATIN9 --> UTF8
-SELECT CONVERT('foo' USING iso_8859_15_to_utf8);
- convert_using 
----------------
- foo
-(1 row)
-
 SELECT CONVERT('foo', 'LATIN9', 'UTF8');
  convert 
 ---------
@@ -1201,12 +661,6 @@ SELECT CONVERT('foo', 'LATIN9', 'UTF8');
 (1 row)
 
 -- UTF8 --> LATIN10
-SELECT CONVERT('foo' USING utf8_to_iso_8859_16);
- convert_using 
----------------
- foo
-(1 row)
-
 SELECT CONVERT('foo', 'UTF8', 'LATIN10');
  convert 
 ---------
@@ -1214,12 +668,6 @@ SELECT CONVERT('foo', 'UTF8', 'LATIN10');
 (1 row)
 
 -- LATIN10 --> UTF8
-SELECT CONVERT('foo' USING iso_8859_16_to_utf8);
- convert_using 
----------------
- foo
-(1 row)
-
 SELECT CONVERT('foo', 'LATIN10', 'UTF8');
  convert 
 ---------
@@ -1227,12 +675,6 @@ SELECT CONVERT('foo', 'LATIN10', 'UTF8');
 (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 
 ---------
@@ -1240,12 +682,6 @@ SELECT CONVERT('foo', 'UTF8', 'ISO-8859-5');
 (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 
 ---------
@@ -1253,12 +689,6 @@ SELECT CONVERT('foo', 'ISO-8859-5', 'UTF8');
 (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 
 ---------
@@ -1266,12 +696,6 @@ SELECT CONVERT('foo', 'UTF8', 'ISO-8859-6');
 (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 
 ---------
@@ -1279,12 +703,6 @@ SELECT CONVERT('foo', 'ISO-8859-6', 'UTF8');
 (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 
 ---------
@@ -1292,12 +710,6 @@ SELECT CONVERT('foo', 'UTF8', 'ISO-8859-7');
 (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 
 ---------
@@ -1305,12 +717,6 @@ SELECT CONVERT('foo', 'ISO-8859-7', 'UTF8');
 (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 
 ---------
@@ -1318,12 +724,6 @@ SELECT CONVERT('foo', 'UTF8', 'ISO-8859-8');
 (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 
 ---------
@@ -1331,12 +731,6 @@ SELECT CONVERT('foo', 'ISO-8859-8', 'UTF8');
 (1 row)
 
 -- LATIN1 --> UTF8
-SELECT CONVERT('foo' USING iso_8859_1_to_utf8);
- convert_using 
----------------
- foo
-(1 row)
-
 SELECT CONVERT('foo', 'LATIN1', 'UTF8');
  convert 
 ---------
@@ -1344,12 +738,6 @@ SELECT CONVERT('foo', 'LATIN1', 'UTF8');
 (1 row)
 
 -- UTF8 --> LATIN1
-SELECT CONVERT('foo' USING utf8_to_iso_8859_1);
- convert_using 
----------------
- foo
-(1 row)
-
 SELECT CONVERT('foo', 'UTF8', 'LATIN1');
  convert 
 ---------
@@ -1357,12 +745,6 @@ SELECT CONVERT('foo', 'UTF8', 'LATIN1');
 (1 row)
 
 -- JOHAB --> UTF8
-SELECT CONVERT('foo' USING johab_to_utf8);
- convert_using 
----------------
- foo
-(1 row)
-
 SELECT CONVERT('foo', 'JOHAB', 'UTF8');
  convert 
 ---------
@@ -1370,12 +752,6 @@ SELECT CONVERT('foo', 'JOHAB', 'UTF8');
 (1 row)
 
 -- UTF8 --> JOHAB
-SELECT CONVERT('foo' USING utf8_to_johab);
- convert_using 
----------------
- foo
-(1 row)
-
 SELECT CONVERT('foo', 'UTF8', 'JOHAB');
  convert 
 ---------
@@ -1383,12 +759,6 @@ SELECT CONVERT('foo', 'UTF8', 'JOHAB');
 (1 row)
 
 -- SJIS --> UTF8
-SELECT CONVERT('foo' USING sjis_to_utf8);
- convert_using 
----------------
- foo
-(1 row)
-
 SELECT CONVERT('foo', 'SJIS', 'UTF8');
  convert 
 ---------
@@ -1396,12 +766,6 @@ SELECT CONVERT('foo', 'SJIS', 'UTF8');
 (1 row)
 
 -- UTF8 --> SJIS
-SELECT CONVERT('foo' USING utf8_to_sjis);
- convert_using 
----------------
- foo
-(1 row)
-
 SELECT CONVERT('foo', 'UTF8', 'SJIS');
  convert 
 ---------
@@ -1409,12 +773,6 @@ SELECT CONVERT('foo', 'UTF8', 'SJIS');
 (1 row)
 
 -- WIN1258 --> UTF8
-SELECT CONVERT('foo' USING windows_1258_to_utf8);
- convert_using 
----------------
- foo
-(1 row)
-
 SELECT CONVERT('foo', 'WIN1258', 'UTF8');
  convert 
 ---------
@@ -1422,12 +780,6 @@ SELECT CONVERT('foo', 'WIN1258', 'UTF8');
 (1 row)
 
 -- UTF8 --> WIN1258
-SELECT CONVERT('foo' USING utf8_to_windows_1258);
- convert_using 
----------------
- foo
-(1 row)
-
 SELECT CONVERT('foo', 'UTF8', 'WIN1258');
  convert 
 ---------
@@ -1435,12 +787,6 @@ SELECT CONVERT('foo', 'UTF8', 'WIN1258');
 (1 row)
 
 -- UHC --> UTF8
-SELECT CONVERT('foo' USING uhc_to_utf8);
- convert_using 
----------------
- foo
-(1 row)
-
 SELECT CONVERT('foo', 'UHC', 'UTF8');
  convert 
 ---------
@@ -1448,12 +794,6 @@ SELECT CONVERT('foo', 'UHC', 'UTF8');
 (1 row)
 
 -- UTF8 --> UHC
-SELECT CONVERT('foo' USING utf8_to_uhc);
- convert_using 
----------------
- foo
-(1 row)
-
 SELECT CONVERT('foo', 'UTF8', 'UHC');
  convert 
 ---------
@@ -1461,12 +801,6 @@ SELECT CONVERT('foo', 'UTF8', 'UHC');
 (1 row)
 
 -- UTF8 --> WIN1250
-SELECT CONVERT('foo' USING utf8_to_windows_1250);
- convert_using 
----------------
- foo
-(1 row)
-
 SELECT CONVERT('foo', 'UTF8', 'WIN1250');
  convert 
 ---------
@@ -1474,12 +808,6 @@ SELECT CONVERT('foo', 'UTF8', 'WIN1250');
 (1 row)
 
 -- WIN1250 --> UTF8
-SELECT CONVERT('foo' USING windows_1250_to_utf8);
- convert_using 
----------------
- foo
-(1 row)
-
 SELECT CONVERT('foo', 'WIN1250', 'UTF8');
  convert 
 ---------
@@ -1487,12 +815,6 @@ SELECT CONVERT('foo', 'WIN1250', 'UTF8');
 (1 row)
 
 -- UTF8 --> WIN1256
-SELECT CONVERT('foo' USING utf8_to_windows_1256);
- convert_using 
----------------
- foo
-(1 row)
-
 SELECT CONVERT('foo', 'UTF8', 'WIN1256');
  convert 
 ---------
@@ -1500,12 +822,6 @@ SELECT CONVERT('foo', 'UTF8', 'WIN1256');
 (1 row)
 
 -- WIN1256 --> UTF8
-SELECT CONVERT('foo' USING windows_1256_to_utf8);
- convert_using 
----------------
- foo
-(1 row)
-
 SELECT CONVERT('foo', 'WIN1256', 'UTF8');
  convert 
 ---------
@@ -1513,12 +829,6 @@ SELECT CONVERT('foo', 'WIN1256', 'UTF8');
 (1 row)
 
 -- UTF8 --> WIN874
-SELECT CONVERT('foo' USING utf8_to_windows_874);
- convert_using 
----------------
- foo
-(1 row)
-
 SELECT CONVERT('foo', 'UTF8', 'WIN874');
  convert 
 ---------
@@ -1526,12 +836,6 @@ SELECT CONVERT('foo', 'UTF8', 'WIN874');
 (1 row)
 
 -- WIN874 --> UTF8
-SELECT CONVERT('foo' USING windows_874_to_utf8);
- convert_using 
----------------
- foo
-(1 row)
-
 SELECT CONVERT('foo', 'WIN874', 'UTF8');
  convert 
 ---------
@@ -1539,12 +843,6 @@ SELECT CONVERT('foo', 'WIN874', 'UTF8');
 (1 row)
 
 -- UTF8 --> WIN1253
-SELECT CONVERT('foo' USING utf8_to_windows_1253);
- convert_using 
----------------
- foo
-(1 row)
-
 SELECT CONVERT('foo', 'UTF8', 'WIN1253');
  convert 
 ---------
@@ -1552,12 +850,6 @@ SELECT CONVERT('foo', 'UTF8', 'WIN1253');
 (1 row)
 
 -- WIN1253 --> UTF8
-SELECT CONVERT('foo' USING windows_1253_to_utf8);
- convert_using 
----------------
- foo
-(1 row)
-
 SELECT CONVERT('foo', 'WIN1253', 'UTF8');
  convert 
 ---------
@@ -1565,12 +857,6 @@ SELECT CONVERT('foo', 'WIN1253', 'UTF8');
 (1 row)
 
 -- UTF8 --> WIN1254
-SELECT CONVERT('foo' USING utf8_to_windows_1254);
- convert_using 
----------------
- foo
-(1 row)
-
 SELECT CONVERT('foo', 'UTF8', 'WIN1254');
  convert 
 ---------
@@ -1578,12 +864,6 @@ SELECT CONVERT('foo', 'UTF8', 'WIN1254');
 (1 row)
 
 -- WIN1254 --> UTF8
-SELECT CONVERT('foo' USING windows_1254_to_utf8);
- convert_using 
----------------
- foo
-(1 row)
-
 SELECT CONVERT('foo', 'WIN1254', 'UTF8');
  convert 
 ---------
@@ -1591,12 +871,6 @@ SELECT CONVERT('foo', 'WIN1254', 'UTF8');
 (1 row)
 
 -- UTF8 --> WIN1255
-SELECT CONVERT('foo' USING utf8_to_windows_1255);
- convert_using 
----------------
- foo
-(1 row)
-
 SELECT CONVERT('foo', 'UTF8', 'WIN1255');
  convert 
 ---------
@@ -1604,12 +878,6 @@ SELECT CONVERT('foo', 'UTF8', 'WIN1255');
 (1 row)
 
 -- WIN1255 --> UTF8
-SELECT CONVERT('foo' USING windows_1255_to_utf8);
- convert_using 
----------------
- foo
-(1 row)
-
 SELECT CONVERT('foo', 'WIN1255', 'UTF8');
  convert 
 ---------
@@ -1617,12 +885,6 @@ SELECT CONVERT('foo', 'WIN1255', 'UTF8');
 (1 row)
 
 -- UTF8 --> WIN1257
-SELECT CONVERT('foo' USING utf8_to_windows_1257);
- convert_using 
----------------
- foo
-(1 row)
-
 SELECT CONVERT('foo', 'UTF8', 'WIN1257');
  convert 
 ---------
@@ -1630,12 +892,6 @@ SELECT CONVERT('foo', 'UTF8', 'WIN1257');
 (1 row)
 
 -- WIN1257 --> UTF8
-SELECT CONVERT('foo' USING windows_1257_to_utf8);
- convert_using 
----------------
- foo
-(1 row)
-
 SELECT CONVERT('foo', 'WIN1257', 'UTF8');
  convert 
 ---------
@@ -1643,12 +899,6 @@ SELECT CONVERT('foo', 'WIN1257', 'UTF8');
 (1 row)
 
 -- UTF8 --> EUC_JIS_2004
-SELECT CONVERT('foo' USING utf8_to_euc_jis_2004);
- convert_using 
----------------
- foo
-(1 row)
-
 SELECT CONVERT('foo', 'UTF8', 'EUC_JIS_2004');
  convert 
 ---------
@@ -1656,12 +906,6 @@ SELECT CONVERT('foo', 'UTF8', 'EUC_JIS_2004');
 (1 row)
 
 -- EUC_JIS_2004 --> UTF8
-SELECT CONVERT('foo' USING euc_jis_2004_to_utf8);
- convert_using 
----------------
- foo
-(1 row)
-
 SELECT CONVERT('foo', 'EUC_JIS_2004', 'UTF8');
  convert 
 ---------
@@ -1669,12 +913,6 @@ SELECT CONVERT('foo', 'EUC_JIS_2004', 'UTF8');
 (1 row)
 
 -- UTF8 --> SHIFT_JIS_2004
-SELECT CONVERT('foo' USING utf8_to_euc_jis_2004);
- convert_using 
----------------
- foo
-(1 row)
-
 SELECT CONVERT('foo', 'UTF8', 'SHIFT_JIS_2004');
  convert 
 ---------
@@ -1682,12 +920,6 @@ SELECT CONVERT('foo', 'UTF8', 'SHIFT_JIS_2004');
 (1 row)
 
 -- SHIFT_JIS_2004 --> UTF8
-SELECT CONVERT('foo' USING shift_jis_2004_to_utf8);
- convert_using 
----------------
- foo
-(1 row)
-
 SELECT CONVERT('foo', 'SHIFT_JIS_2004', 'UTF8');
  convert 
 ---------
@@ -1695,12 +927,6 @@ SELECT CONVERT('foo', 'SHIFT_JIS_2004', 'UTF8');
 (1 row)
 
 -- EUC_JIS_2004 --> SHIFT_JIS_2004
-SELECT CONVERT('foo' USING euc_jis_2004_to_shift_jis_2004);
- convert_using 
----------------
- foo
-(1 row)
-
 SELECT CONVERT('foo', 'EUC_JIS_2004', 'SHIFT_JIS_2004');
  convert 
 ---------
@@ -1708,12 +934,6 @@ SELECT CONVERT('foo', 'EUC_JIS_2004', 'SHIFT_JIS_2004');
 (1 row)
 
 -- SHIFT_JIS_2004 --> EUC_JIS_2004
-SELECT CONVERT('foo' USING shift_jis_2004_to_euc_jis_2004);
- convert_using 
----------------
- foo
-(1 row)
-
 SELECT CONVERT('foo', 'SHIFT_JIS_2004', 'EUC_JIS_2004');
  convert 
 ---------
diff --git a/src/test/regress/sql/conversion.sql b/src/test/regress/sql/conversion.sql
index be5c8628f55..99a9178315e 100644
--- a/src/test/regress/sql/conversion.sql
+++ b/src/test/regress/sql/conversion.sql
@@ -28,394 +28,264 @@ 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');
 -- UTF8 --> EUC_JIS_2004
-SELECT CONVERT('foo' USING utf8_to_euc_jis_2004);
 SELECT CONVERT('foo', 'UTF8', 'EUC_JIS_2004');
 -- EUC_JIS_2004 --> UTF8
-SELECT CONVERT('foo' USING euc_jis_2004_to_utf8);
 SELECT CONVERT('foo', 'EUC_JIS_2004', 'UTF8');
 -- UTF8 --> SHIFT_JIS_2004
-SELECT CONVERT('foo' USING utf8_to_euc_jis_2004);
 SELECT CONVERT('foo', 'UTF8', 'SHIFT_JIS_2004');
 -- SHIFT_JIS_2004 --> UTF8
-SELECT CONVERT('foo' USING shift_jis_2004_to_utf8);
 SELECT CONVERT('foo', 'SHIFT_JIS_2004', 'UTF8');
 -- EUC_JIS_2004 --> SHIFT_JIS_2004
-SELECT CONVERT('foo' USING euc_jis_2004_to_shift_jis_2004);
 SELECT CONVERT('foo', 'EUC_JIS_2004', 'SHIFT_JIS_2004');
 -- SHIFT_JIS_2004 --> EUC_JIS_2004
-SELECT CONVERT('foo' USING shift_jis_2004_to_euc_jis_2004);
 SELECT CONVERT('foo', 'SHIFT_JIS_2004', 'EUC_JIS_2004');
 --
 -- return to the super user