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

Any chance there's ever going to be HEX escaping?

Ian Barwick wrote:

> On Friday 13 June 2003 00:13, Roland Glenn McIntosh wrote:
>
>>I would like to insert a EuroSign as two byte character number 20AC.
>>Is there a way I can do this from an ISO-8859-1 (latin1) terminal emulator
>>via the psql tool? Is there an entity scheme?
>>
>>I tried various permutations of the following to no avail:
>> INSERT INTO mytable VALUES('currency_symbol','\u20AC');
>
>
> Use escaped octal codes:
> INSERT INTO my_tbl (unitxt) VALUES('\303\244')
> (replace '\303\244' with whatever 20AC is in octal), or if you prefer typing
> to maths:
>
> INSERT INTO my_tbl (unitxt) VALUES(encode(decode('c3a4','hex'), 'escape'))
>
> Ian Barwick
> barwick(at)gmx(dot)net
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
>