From 6206a880cf233e5bf70a0ced6be810c399c7e006 Mon Sep 17 00:00:00 2001 From: Tatsuo Ishii Date: Tue, 6 Aug 2002 05:40:47 +0000 Subject: Add SQL99 CONVERT() function. --- doc/src/sgml/func.sgml | 414 ++++++++++++++++++++++++++++++++++++++++++++++++- 1 file changed, 413 insertions(+), 1 deletion(-) (limited to 'doc/src') diff --git a/doc/src/sgml/func.sgml b/doc/src/sgml/func.sgml index dfebb45e1bc..aed47db79b9 100644 --- a/doc/src/sgml/func.sgml +++ b/doc/src/sgml/func.sgml @@ -1,5 +1,5 @@ @@ -857,6 +857,19 @@ PostgreSQL documentation 4 + + convert(string + using conversion_name) + text + Change encoding using specified conversion name. + Conversions can be defined by CREATE CONVERSION. + Also there are some pre-defined conversion names. + See for available + conversion names. + convert('PostgreSQL' using iso8859_1_to_utf8) + 'PostgreSQL' in UNICODE(UTF-8) encoding + + lower(string) text @@ -947,6 +960,405 @@ PostgreSQL documentation + + Available conversion names + + + + conversion + source encoding + destination encoding + + + + + ascii_to_utf8 + SQL_ASCII + UNICODE + + + + big5_to_euc_tw + BIG5 + EUC_TW + + + + big5_to_mic + BIG5 + MULE_INTERNAL + + + + big5_to_utf8 + BIG5 + UNICODE + + + + euc_cn_to_utf8 + EUC_CN + UNICODE + + + + euc_jp_to_mic + EUC_JP + MULE_INTERNAL + + + + euc_jp_to_sjis + EUC_JP + SJIS + + + + euc_jp_to_utf8 + EUC_JP + UNICODE + + + + euc_kr_to_utf8 + EUC_KR + UNICODE + + + + euc_tw_to_big5 + EUC_TW + BIG5 + + + + euc_tw_to_mic + EUC_TW + MULE_INTERNAL + + + + euc_tw_to_utf8 + EUC_TW + UNICODE + + + + gb18030_to_utf8 + GB18030 + UNICODE + + + + gbk_to_utf8 + GBK + UNICODE + + + + iso8859_10_to_utf8 + LATIN6 + UNICODE + + + + iso8859_13_to_utf8 + LATIN7 + UNICODE + + + + iso8859_14_to_utf8 + LATIN8 + UNICODE + + + + iso8859_15_to_utf8 + LATIN9 + UNICODE + + + + iso8859_16_to_utf8 + LATIN10 + UNICODE + + + + iso8859_1_to_utf8 + LATIN1 + UNICODE + + + + iso8859_2_to_utf8 + LATIN2 + UNICODE + + + + iso8859_3_to_utf8 + LATIN3 + UNICODE + + + + iso8859_4_to_utf8 + LATIN4 + UNICODE + + + + iso8859_5_to_utf8 + ISO_8859_5 + UNICODE + + + + iso8859_6_to_utf8 + ISO_8859_6 + UNICODE + + + + iso8859_7_to_utf8 + ISO_8859_7 + UNICODE + + + + iso8859_8_to_utf8 + ISO_8859_8 + UNICODE + + + + iso8859_9_to_utf8 + LATIN5 + UNICODE + + + + johab_to_utf8 + JOHAB + UNICODE + + + + mic_to_big5 + MULE_INTERNAL + BIG5 + + + + mic_to_euc_jp + MULE_INTERNAL + EUC_JP + + + + mic_to_euc_tw + MULE_INTERNAL + EUC_TW + + + + mic_to_sjis + MULE_INTERNAL + SJIS + + + + sjis_to_euc_jp + SJIS + EUC_JP + + + + sjis_to_mic + SJIS + MULE_INTERNAL + + + + sjis_to_utf8 + SJIS + UNICODE + + + + tcvn_to_utf8 + TCVN + UNICODE + + + + uhc_to_utf8 + UHC + UNICODE + + + + utf8_to_ascii + UNICODE + SQL_ASCII + + + + utf8_to_big5 + UNICODE + BIG5 + + + + utf8_to_euc_cn + UNICODE + EUC_CN + + + + utf8_to_euc_jp + UNICODE + EUC_JP + + + + utf8_to_euc_kr + UNICODE + EUC_KR + + + + utf8_to_euc_tw + UNICODE + EUC_TW + + + + utf8_to_gb18030 + UNICODE + GB18030 + + + + utf8_to_gbk + UNICODE + GBK + + + + utf8_to_iso8859_1 + UNICODE + LATIN1 + + + + utf8_to_iso8859_10 + UNICODE + LATIN6 + + + + utf8_to_iso8859_13 + UNICODE + LATIN7 + + + + utf8_to_iso8859_14 + UNICODE + LATIN8 + + + + utf8_to_iso8859_15 + UNICODE + LATIN9 + + + + utf8_to_iso8859_16 + UNICODE + LATIN10 + + + + utf8_to_iso8859_2 + UNICODE + LATIN2 + + + + utf8_to_iso8859_3 + UNICODE + LATIN3 + + + + utf8_to_iso8859_4 + UNICODE + LATIN4 + + + + utf8_to_iso8859_5 + UNICODE + ISO_8859_5 + + + + utf8_to_iso8859_6 + UNICODE + ISO_8859_6 + + + + utf8_to_iso8859_7 + UNICODE + ISO_8859_7 + + + + utf8_to_iso8859_8 + UNICODE + ISO_8859_8 + + + + utf8_to_iso8859_9 + UNICODE + LATIN5 + + + + utf8_to_johab + UNICODE + JOHAB + + + + utf8_to_sjis + UNICODE + SJIS + + + + utf8_to_tcvn + UNICODE + TCVN + + + + utf8_to_uhc + UNICODE + UHC + + + + +
+ Additional string manipulation functions are available and are listed below. Some of them are used internally to implement the -- cgit v1.2.3