HOw to convert unicode to string

From: "Abhijit Prusty -X (abprusty - UST Global at Cisco)" <abprusty(at)cisco(dot)com>
To: "pgsql-sql(at)postgresql(dot)org" <pgsql-sql(at)postgresql(dot)org>
Subject: HOw to convert unicode to string
Date: 2012-09-23 14:41:09
Message-ID: 8A2A33BFAA5E2F408D0BBB80844412720487D0@xmb-aln-x03.cisco.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hi,

I have a query in oracle like this mentioned below

Insert into TEST
(TEMPLATE_ID, TEMPLATE_NAME, CREATED_BY, CREATED_DT, UPDATED_BY,
UPDATED_DT, TEMPLATE_KEY)
Values
(1, UNISTR('\D3C9\BA85\B3C4 \B514\C2A4\D50C\B808\C774'), 'dmin', SYSDATE, 'admin',
SYSDATE ,'FLOOR');

Now the oracle uses the UNISTR function to convert and insert the Unicode to string and store in database.

But, how can we achieve the same using the PostgreSql .Can you please help me with the query

Thanks,
Abhijit

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Jasen Betts 2012-09-26 12:50:53 Re: HOw to convert unicode to string
Previous Message Dmitriy Igrishin 2012-09-23 07:29:29 Re: transactions and ecpg