xml to string, ascii x utf8 conversion

From: Radek Novotný <radek(dot)novotny(at)mediawork(dot)cz>
To: pgsql-general(at)postgresql(dot)org
Subject: xml to string, ascii x utf8 conversion
Date: 2009-07-20 16:46:01
Message-ID: 200907201846.01359.radek.novotny@mediawork.cz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,
having problem with conversion while doing function query_to_xml.

query_to_xml('select Nazev as "TITLE", Datum as "DATE", Autor_Akce as "meta
rel=''action_author''", ....

gave me

<table xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<row>
<TITLE>Test</TITLE>
<DATE>2009-07-20</DATE>
<meta_x0020_rel_x003D__x0027_action_author_x0027_>test
</meta_x0020_rel_x003D__x0027_action_author_x0027_>

How can i transcode this well generated xml(ascii) to string(UTF8) without the
escape characters?

I found nothing on google...

Regards,
Radek Novotny

--

www.publicstream.cz - vytvořili jsme produkt pro živé přenosy (online streaming)
a videoarchív ve formátu FLASH.

Bc. Radek Novotný
jednatel Mediawork group s.r.o.

tel.: +420 724 020 361
email: radek(dot)novotny(at)mediawork(dot)cz
http://www.mediawork.cz

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Dan Armbrust 2009-07-20 16:50:30 Re: Checkpoint Tuning Question
Previous Message Martijn van Oosterhout 2009-07-20 15:37:55 Re: Documentation Improvement suggestions