Re: How can I insert a UTF-8 character with psql?

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(at)gmx(dot)net