Skip to main content

TOASCII

Categories: Conversion, String

TOASCII

Converts a string that is encoded in the specified character set to UTF-8.

Syntax

TOASCII(string_expression STRING, character_encoding TYPE) → STRING

  • string_expression: The string to convert to the specified character encoding.
  • character_encoding: The character set that the string is encoded in.

Examples

Converts the string "Smith" from its current character encoding to a string encoded in UTF-8.
SELECT TOASCII('Smith', 'Windows-1250')
-- Smith

Usage Notes

These are the supported character encodings:

  • ASCII
  • Big5
  • CP437
  • CP737
  • CP850
  • CP852
  • CP855
  • CP857
  • CP858
  • CP860
  • CP861
  • CP862
  • CP863
  • CP865
  • CP866
  • CP869
  • EUC-JP
  • EUC-KR
  • GBK
  • ISCII
  • ISO-2022-JP
  • ISO-2022-KR
  • ISO-8859-1
  • ISO-8859-2
  • ISO-8859-3
  • ISO-8859-4
  • ISO-8859-5
  • ISO-8859-6
  • ISO-8859-7
  • ISO-8859-8
  • ISO-8859-9
  • ISO-8859-11
  • ISO-8859-13
  • ISO-8859-15
  • KOI8-R
  • KOI8-U
  • UTF-8/UTF8
  • UTF-16/UTF16
  • UTF-32/UTF32
  • Windows-1250
  • Windows-1251
  • Windows-1252
  • Windows-1253
  • Windows-1254
  • Windows-1255
  • Windows-1256
  • Windows-1257
  • Windows-1258