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