Skip to main content

Version: current [25.x]

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:

Syntax
- TOASCII(string_expression STRING, character_encoding TYPE) → STRING
Usage Notes