PostgreSQL CONVERT
From w3cyberlearnings
Contents |
Postgresql convert
Convert string to dest_encoding. The original encoding is specified by src_encoding. The string must be valid in this encoding.
Syntax convert
convert(string bytea, src_encoding name, dest_encoding name)
Example 1
test2=# SELECT convert('something string', 'UTF8', 'ISO_8859_2'); convert ------------------------------------ \x736f6d657468696e6720737472696e67 (1 row)