agora inbox for pgsql-sql@postgresql.org
help / color / mirror / Atom feedOctal to UTF-8
2+ messages / 2 participants
[nested] [flat]
* Octal to UTF-8
@ 2015-07-09 09:21 Weiss, Jörg <J.Weiss@dvz-mv.de>
0 siblings, 1 reply; 2+ messages in thread
From: Weiss, Jörg @ 2015-07-09 09:21 UTC (permalink / raw)
To: pgsql-sql
Hi!
This is a post, based on a post of me before.
How can I convert the octal-code output of of an encode("text",'escape') to utf-8?
I wont to convert "f\303\274r" INTO "für" or "m\303\266chte" into "möchte"!
regards
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Octal to UTF-8
@ 2015-07-09 09:35 Vinayak <vinpokale@gmail.com>
parent: Weiss, Jörg <J.Weiss@dvz-mv.de>
0 siblings, 0 replies; 2+ messages in thread
From: Vinayak @ 2015-07-09 09:35 UTC (permalink / raw)
To: 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.
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2015-07-09 09:35 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2015-07-09 09:21 Octal to UTF-8 Weiss, Jörg <J.Weiss@dvz-mv.de>
2015-07-09 09:35 ` Vinayak <vinpokale@gmail.com>
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox