Re: Octal to UTF-8

From: Vinayak <vinpokale(at)gmail(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: Octal to UTF-8
Date: 2015-07-09 09:35:19
Message-ID: 1436434519739-5857342.post@n5.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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.

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Alex Ignatov 2015-07-09 10:03:59 Strange DOMAIN behavior
Previous Message Weiss 2015-07-09 09:21:36 Octal to UTF-8