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
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

Last updated