| 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 18:08:18 |
| Message-ID: | 200205192008.18893.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 |
Le Dimanche 19 Mai 2002 11:44, Patrice Hédé a écrit :
> The function is taking the first character of a TEXT element, and
> returns its UCS2 value. I just did some basic test (i.e. I have not
> tried with 3 or 4 bytes UTF-8 chars). The function is following the
> Unicode 3.2 spec.
Hi Patrice,
I tried a Japanese character :
SELECT utf8toucs2 ('æ¯'::text) which returns -1
Do you know why it does not return the UCS-2 value?
Cheers,
Jean-Michel POURE
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Patrice Hédé | 2002-05-19 19:14:42 | Re: [HACKERS] UTF-8 safe ascii() function |
| Previous Message | Jean-Michel POURE | 2002-05-19 10:44:56 | Re: [HACKERS] UTF-8 safe ascii() function |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Patrice Hédé | 2002-05-19 19:14:42 | Re: [HACKERS] UTF-8 safe ascii() function |
| Previous Message | Tom Lane | 2002-05-19 17:31:25 | Re: Walking a view to find all source tables |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2002-05-19 18:53:27 | ScanCommandId should become part of snapshot |
| Previous Message | Tom Lane | 2002-05-19 17:37:01 | Re: Unbounded (Possibly) Database Size Increase - Toasting |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Patrice Hédé | 2002-05-19 19:14:42 | Re: [HACKERS] UTF-8 safe ascii() function |
| Previous Message | Jean-Michel POURE | 2002-05-19 10:44:56 | Re: [HACKERS] UTF-8 safe ascii() function |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Patrice Hédé | 2002-05-19 19:14:42 | Re: [HACKERS] UTF-8 safe ascii() function |
| Previous Message | Jean-Michel POURE | 2002-05-19 10:44:56 | Re: [HACKERS] UTF-8 safe ascii() function |