HOw to convert unicode to string - Mailing list pgsql-sql

From Abhijit Prusty -X (abprusty - UST Global at Cisco)"
Subject HOw to convert unicode to string
Date
Msg-id 8A2A33BFAA5E2F408D0BBB80844412720487D0@xmb-aln-x03.cisco.com
Whole thread Raw
List pgsql-sql
<div class="WordSection1"><p class="MsoNormal">Hi,<p class="MsoNormal"> <p class="MsoNormal">I have a query in oracle
likethis mentioned below<p class="MsoNormal"> <p class="MsoNormal">Insert into TEST<p class="MsoNormal">  
(TEMPLATE_ID,TEMPLATE_NAME, CREATED_BY, CREATED_DT, UPDATED_BY, <p class="MsoNormal">    UPDATED_DT, TEMPLATE_KEY)<p
class="MsoNormal">Values<pclass="MsoNormal">   (1, UNISTR('\D3C9\BA85\B3C4 \B514\C2A4\D50C\B808\C774'), 'dmin',
SYSDATE,'admin', <p class="MsoNormal">    SYSDATE ,'FLOOR');<p class="MsoNormal"> <p class="MsoNormal">Now the oracle
usesthe UNISTR function to convert and insert the Unicode to string and store in database.<p class="MsoNormal"> <p
class="MsoNormal">But,how can we achieve the same using the PostgreSql .Can you please help me with the query<p
class="MsoNormal"> <pclass="MsoNormal"> <p class="MsoNormal">Thanks,<p class="MsoNormal">Abhijit</div> 

pgsql-sql by date:

Previous
From: Dmitriy Igrishin
Date:
Subject: Re: transactions and ecpg
Next
From: Matthias Nagel
Date:
Subject: Reuse temporary calculation results in an SQL update query