Jump to: navigation, search

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)

Related Links


Navigation
Web
SQL
MISC
References