Thread: return encoding results

return encoding results

From
Emi Lu
Date:
<small>Hello, <br /><br /> Does psql provide function that can return specific encoding results? For example, <br /><br
/>select function_name('é', unicode); <br /><br /> To return:      \u00e9<br /><br /> Thanks a lot!<br /> Emi<br />
--<br/> select function_name('</small><small><small>á</small>', unicode);  To return: </small><small><small>\u00e0<br
/>... ...<br /></small>á  \u00e0   Á  \u00c0<br /> à  \u00e1   À  \u00c1<br /> â  \u00e2     \u00c2<br /> é  \u00e9  
É \u00c9<br /> è  \u00e8   È  \u00c8<br /> ê  \u00ea   Ê  \u00ca<br /> î  \u00ee   Π \u00ce<br /> ç  \u00e7   Ç 
\u00c7<br /></small> 

Re: return encoding results

From
Andreas Kretschmer
Date:
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°