Postgres Pro
Downloads
Home   >   mailing lists

Re: Octal to UTF-8 - Mailing list pgsql-sql

From Vinayak
Subject Re: Octal to UTF-8
Date
Msg-id 1436434519739-5857342.post@n5.nabble.com
Whole thread Raw
In response to Octal to UTF-8  (Weiss, Jörg <J.Weiss@dvz-mv.de>)
List pgsql-sql
Tree view 
Hi,

>I wont to convert "f\303\274r" INTO "für" or "m\303\266chte" into "möchte"!
The below function might be useful.
postgres=# select convert_from('f\303\274r','UTF8');convert_from
--------------für
(1 row)

postgres=# select convert_from('m\303\266chte','UTF8');convert_from
--------------möchte
(1 row)
Regards,
Vinayak



-----
Regards,
Vinayak,

--
View this message in context: http://postgresql.nabble.com/Octal-to-UTF-8-tp5857341p5857342.html
Sent from the PostgreSQL - sql mailing list archive at Nabble.com.

pgsql-sql by date:

Previous
From: Weiss, Jörg
Date:
Subject: Octal to UTF-8
Next
From: Alex Ignatov
Date:
Subject: Strange DOMAIN behavior