Functions / String Functions And Operators
Converts string to ASCII from another encoding, which may be identified by name or number.
Reading PG 18current·documented in 27 of 27 versions, 7.1 to 20
to_ascii ( string text ) → textConverts
string to ASCII from another encoding, which may be identified by name or number. If encoding is omitted the database encoding is assumed (which in practice is the only useful case). The conversion consists primarily of dropping accents. Conversion is only supported from LATIN1, LATIN2, LATIN9, and WIN1250 encodings. (See the unaccent module for another, more flexible solution.)to_ascii('Karél') → Karelto_ascii ( string text, encoding name ) → textConverts
string to ASCII from another encoding, which may be identified by name or number. If encoding is omitted the database encoding is assumed (which in practice is the only useful case). The conversion consists primarily of dropping accents. Conversion is only supported from LATIN1, LATIN2, LATIN9, and WIN1250 encodings. (See the unaccent module for another, more flexible solution.)to_ascii('Karél') → Karelto_ascii ( string text, encoding integer ) → textConverts
string to ASCII from another encoding, which may be identified by name or number. If encoding is omitted the database encoding is assumed (which in practice is the only useful case). The conversion consists primarily of dropping accents. Conversion is only supported from LATIN1, LATIN2, LATIN9, and WIN1250 encodings. (See the unaccent module for another, more flexible solution.)to_ascii('Karél') → KarelDefinition snapshot: b7bd9cda · English manual source