On Thu, Mar 13, 2008 at 03:49:37PM +0100, Hans Schou wrote: > Hi > > I have a little trouble with the chr() function. > > I have a string like this: > "Copyright+%C2%A9+1856+Na%C3%AFve+retros%C2%AE" > which should be converted to binary string like: > "Copyright © 1856 Naïve retros®" > > Is there an easy way to do this conversion? Looks like you have UTF-8 encoded with percent signs. Perhaps the right approach is you covert the incoming text into a bytea array and then use convert() to turn it in to a string. Hope this helps, -- Martijn van Oosterhout <kleptog@xxxxxxxxx> http://svana.org/kleptog/ > Please line up in a tree and maintain the heap invariant while > boarding. Thank you for flying nlogn airlines.
Attachment:
signature.asc
Description: Digital signature
