Re: How can I insert a UTF-8 character with psql? - Mailing list pgsql-general

On Friday 13 June 2003 15:57, Roland Glenn McIntosh wrote:
> Ian - Thank you very much for your reply.  It only seems to half work,
> however. This Euro sign is giving me a headache.
> I tried both of the following:
>
>         UPDATE my_tbl SET value='\40\254' WHERE NAME LIKE 'curr%';
> and
>         UPDATE my_tbl SET value=encode(decode('20ac','hex'), 'escape')
> WHERE NAME LIKE 'curr%'; and
>         UPDATE my_tbl SET value='\040\254' WHERE NAME LIKE 'curr%';

<reminder_to_self>think before posting</reminder_to_self>

You will of course need to convert the two-byte Unicode UCS-2 value into
the UTF-8 equivalent.


Ian Barwick
barwick@gmx.net