for available conversion names. convert(’PostgreSQL’ using iso_8859_1_to_utf_8) ’PostgreSQL’ in Unicode (UTF-8) encoding lower(string) text Convert string to lower case lower(’TOM’) tom octet_length(string) If src_encoding is omitted, database encoding is assumed. convert( ’text_in_unicode’, ’UNICODE’, ’LATIN1’) text_in_unicode represented in ISO 8859-1 encoding decode(string text, type text) bytea Decode ascii_to_utf_8 SQL_ASCII UNICODE big5_to_euc_tw BIG5 EUC_TW big5_to_mic BIG5 MULE_INTERNAL big5_to_utf_8 BIG5 UNICODE euc_cn_to_mic EUC_CN MULE_INTERNAL euc_cn_to_utf_8 EUC_CN UNICODE euc_jp_to_mic EUC_JP

for available conversion names. convert(’PostgreSQL’ using iso_8859_1_to_utf_8) ’PostgreSQL’ in Unicode (UTF-8) encoding lower(string) text Convert string to lower case lower(’TOM’) tom octet_length(string) If src_encoding is omitted, database encoding is assumed. convert( ’text_in_unicode’, ’UNICODE’, ’LATIN1’) text_in_unicode represented in ISO 8859-1 encoding decode(string text, type text) bytea Decode ascii_to_utf_8 SQL_ASCII UNICODE big5_to_euc_tw BIG5 EUC_TW big5_to_mic BIG5 MULE_INTERNAL big5_to_utf_8 BIG5 UNICODE euc_cn_to_mic EUC_CN MULE_INTERNAL euc_cn_to_utf_8 EUC_CN UNICODE euc_jp_to_mic EUC_JP

a particular name or never quote it.) A variant of quoted identifiers allows including escaped Unicode characters identified by their code points. This variant starts with U& (upper or lower case U followed ambiguity with the operator &. Use spaces around the operator to avoid this problem.) Inside the quotes, Unicode characters can be specified in escaped form by writing a backslash followed by the four-digit hexadecimal directly, but are combined into a single code point.) If the server encoding is not UTF-8, the Unicode code point identified by one of these escape sequences is converted to the actual server encoding;

a particular name or never quote it.) A variant of quoted identifiers allows including escaped Unicode characters identified by their code points. This variant starts with U& (upper or lower case U followed ambiguity with the operator &. Use spaces around the operator to avoid this problem.) Inside the quotes, Unicode characters can be specified in escaped form by writing a backslash followed by the four-digit hexadecimal directly, but are combined into a single code point.) If the server encoding is not UTF-8, the Unicode code point identified by one of these escape sequences is converted to the actual server encoding;

with C-style Escapes............................................26 4.1.2.3. String Constants with Unicode Escapes..........................................28 4.1.2.4. Dollar-quoted String Constants..... .............................................................................2302 E.100.3.2.1. Unicode Strings..........................................................2302 E.100.3.3. Object Manipulation s2k-cipher-algo .............................................................2783 F.25.3.7.10. unicode-mode..............................................................2783 F.25.3.8. Generating PGP

C-style Escapes...................................................29 4.1.2.3. String Constants with Unicode Escapes.................................................31 4.1.2.4. Dollar-quoted String Constants .............................................................................2441 E.100.3.2.1. Unicode Strings.................................................................2442 E.100.3.3. Object Manipulation s2k-cipher-algo ....................................................................2952 F.25.3.7.10. unicode-mode.....................................................................2953 F.25.3.8. Generating

a particular name or never quote it.) A variant of quoted identifiers allows including escaped Unicode characters identified by their code points. This variant starts with U& (upper or lower case U followed ambiguity with the operator &. Use spaces around the operator to avoid this problem.) Inside the quotes, Unicode characters can be specified in escaped form by writing a backslash followed by the four-digit hexadecimal directly, but are combined into a single code point.) If the server encoding is not UTF-8, the Unicode code point identified by one of these escape sequences is converted to the actual server encoding;

a particular name or never quote it.) A variant of quoted identifiers allows including escaped Unicode characters identified by their code points. This variant starts with U& (upper or lower case U followed ambiguity with the operator &. Use spaces around the operator to avoid this problem.) Inside the quotes, Unicode characters can be specified in escaped form by writing a backslash followed by the four-digit hexadecimal directly, but are combined into a single code point.) If the server encoding is not UTF-8, the Unicode code point identified by one of these escape sequences is converted to the actual server encoding;

a particular name or never quote it.) A variant of quoted identifiers allows including escaped Unicode characters identified by their code points. This variant starts with U& (upper or lower case U followed ambiguity with the operator &. Use spaces around the operator to avoid this problem.) Inside the quotes, Unicode characters can be specified in escaped form by writing a backslash followed by the four-digit hexadecimal directly, but are combined into a single code point.) If the server encoding is not UTF-8, the Unicode code point identified by one of these escape sequences is converted to the actual server encoding;

a particular name or never quote it.) A variant of quoted identifiers allows including escaped Unicode characters identified by their code points. This variant starts with U& (upper or lower case U followed ambiguity with the operator &. Use spaces around the operator to avoid this problem.) Inside the quotes, Unicode characters can be specified in escaped form by writing a backslash followed by the four-digit hexadecimal directly, but are combined into a single code point.) If the server encoding is not UTF-8, the Unicode code point identified by one of these escape sequences is converted to the actual server encoding;