return encoding results

agora inbox for pgsql-sql@postgresql.org  
help / color / mirror / Atom feed

return encoding results
2+ messages / 2 participants
[nested] [flat]

* return encoding results
@ 2014-10-30 17:37 Emi Lu <emilu@encs.concordia.ca>
  2014-10-30 17:45 ` Re: return encoding results Andreas Kretschmer <akretschmer@spamfence.net>
  0 siblings, 1 reply; 2+ messages in thread

From: Emi Lu @ 2014-10-30 17:37 UTC (permalink / raw)
  To: 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>




^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: return encoding results
  2014-10-30 17:37 return encoding results Emi Lu <emilu@encs.concordia.ca>
@ 2014-10-30 17:45 ` Andreas Kretschmer <akretschmer@spamfence.net>
  0 siblings, 0 replies; 2+ messages in thread

From: Andreas Kretschmer @ 2014-10-30 17:45 UTC (permalink / raw)
  To: pgsql-sql

Emi Lu <emilu@encs.concordia.ca> wrote:

> Hello,
> 
> Does psql provide function that can return specific encoding results? For
> example,
> 
> select function_name('é', unicode);

Maybe convert(), see:
http://www.postgresql.org/docs/9.3/interactive/functions-string.html 


Andreas
-- 
Really, I'm not out to destroy Microsoft. That will just be a completely
unintentional side effect.                              (Linus Torvalds)
"If I was god, I would recompile penguin with --enable-fly."   (unknown)
Kaufbach, Saxony, Germany, Europe.              N 51.05082°, E 13.56889°


-- 
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql



^ permalink  raw  reply  [nested|flat] 2+ messages in thread

end of thread, other threads:[~2014-10-30 17:45 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2014-10-30 17:37 return encoding results Emi Lu <emilu@encs.concordia.ca>
2014-10-30 17:45 ` Andreas Kretschmer <akretschmer@spamfence.net>

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox