return encoding results

From: Emi Lu <emilu(at)encs(dot)concordia(dot)ca>
To: pgsql-sql(at)postgresql(dot)org
Subject: return encoding results
Date: 2014-10-30 17:37:54
Message-ID: 54527772.2080203@encs.concordia.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

<html>
<head>

<meta http-equiv="content-type" content="text/html; charset=ISO-8859-1">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<small>Hello, <br>
<br>
Does psql provide function that can return specific encoding
results? For example, <br>
<br>
select function_name('&eacute;', unicode); <br>
<br>
To return: &nbsp; &nbsp;&nbsp; \u00e9<br>
<br>
Thanks a lot!<br>
Emi<br>
--<br>
select function_name('</small><small><small>&aacute;</small>', unicode);&nbsp;
To return: </small><small><small>\u00e0<br>
... ...<br>
</small>&aacute;&nbsp; \u00e0&nbsp;&nbsp; &Aacute;&nbsp; \u00c0<br>
&agrave;&nbsp; \u00e1&nbsp;&nbsp; &Agrave;&nbsp; \u00c1<br>
&acirc;&nbsp; \u00e2&nbsp;&nbsp; &Acirc;&nbsp; \u00c2<br>
&eacute;&nbsp; \u00e9&nbsp;&nbsp; &Eacute;&nbsp; \u00c9<br>
&egrave;&nbsp; \u00e8&nbsp;&nbsp; &Egrave;&nbsp; \u00c8<br>
&ecirc;&nbsp; \u00ea&nbsp;&nbsp; &Ecirc;&nbsp; \u00ca<br>
&icirc;&nbsp; \u00ee&nbsp;&nbsp; &Icirc;&nbsp; \u00ce<br>
&ccedil;&nbsp; \u00e7&nbsp;&nbsp; &Ccedil;&nbsp; \u00c7 <br>
</small>
</body>
</html>

Attachment Content-Type Size
unknown_filename text/html 1.2 KB

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Andreas Kretschmer 2014-10-30 17:45:55 Re: return encoding results
Previous Message David G Johnston 2014-10-30 16:48:46 Re: querying within json