Re: [HACKERS] UTF-8 safe ascii() function

From: Jean-Michel POURE <jm(dot)poure(at)freesurf(dot)fr>
To: Patrice Hédé <phede-ml(at)islande(dot)org>, pgsql-general(at)postgresql(dot)org
Subject: Re: [HACKERS] UTF-8 safe ascii() function
Date: 2002-05-19 10:44:56
Message-ID: 200205191244.56474.jm.poure@freesurf.fr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-general pgsql-hackers pgsql-interfaces pgsql-odbc

Dear Patrice,

Thank you very much. This will save the lives of Java users.

> I don't think the function I did is useful as such. It would be better
> to make a function that converts the whole string or something.

Yes, this would save the lives of some Javascript users. Java Unicode notation
is the only Unicode understood by Javascript.

> By the way, what is the encoding for Java Unicode ? is it always "\u"
> followed by 5 hex digits (in which case your example is wrong) ? Then,
> it shouldn't be too difficult to make the relevant function, though I'm
> wondering if the Java programme would convert an incoming '\' 'u' '0'
> '0' '2' '3' '3' to the corresponding UCS2/UTF16 character ?

Java Unicode notation is not case sensitive ('\u' = '\U') and is followed by
an hexadecimal value.

> Maybe we should have some similar input (and output ?) functionality in
> psql, but then I would much prefer the Perl way, which is
> \x{hex_digits}, which is unambiguous.

This would be perfect. We should also handle the HTML unicode nation :
&#{dec_digits} and &#x{hex_digits} as it is unambiguous.

Cheers,
Jean-Michel

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Jean-Michel POURE 2002-05-19 18:08:18 Re: [HACKERS] UTF-8 safe ascii() function
Previous Message Patrice Hédé 2002-05-19 09:44:13 Re: [HACKERS] UTF-8 safe ascii() function

Browse pgsql-general by date

  From Date Subject
Next Message Wm. G. Urquhart 2002-05-19 11:33:49 Re: More on "What am I doing wrong!"
Previous Message Wm. G. Urquhart 2002-05-19 10:03:12 Re: More on "What am I doing wrong!"

Browse pgsql-hackers by date

  From Date Subject
Next Message Peter Eisentraut 2002-05-19 15:17:12 Re: pq_eof() broken with SSL
Previous Message Patrice Hédé 2002-05-19 09:44:13 Re: [HACKERS] UTF-8 safe ascii() function

Browse pgsql-interfaces by date

  From Date Subject
Next Message Jean-Michel POURE 2002-05-19 18:08:18 Re: [HACKERS] UTF-8 safe ascii() function
Previous Message Patrice Hédé 2002-05-19 09:44:13 Re: [HACKERS] UTF-8 safe ascii() function

Browse pgsql-odbc by date

  From Date Subject
Next Message Jean-Michel POURE 2002-05-19 18:08:18 Re: [HACKERS] UTF-8 safe ascii() function
Previous Message Patrice Hédé 2002-05-19 09:44:13 Re: [HACKERS] UTF-8 safe ascii() function