Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-sql by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group