| From: | Jean-Michel POURE <jm(dot)poure(at)freesurf(dot)fr> |
|---|---|
| To: | <pgsql-admin(at)postgresql(dot)org>, pgsql-general <pgsql-general(at)postgresql(dot)org>, pgsql-odbc <pgsql-odbc(at)postgresql(dot)org> |
| Cc: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | UTF-8 safe ascii() function |
| Date: | 2002-05-18 16:53:19 |
| Message-ID: | 200205181853.19420.jm.poure@freesurf.fr |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin pgsql-general pgsql-hackers pgsql-interfaces pgsql-odbc |
Dear all,
I would like to transform UTF-8 strings into Java-Unicode. Example :
- Latin1 : 'é'
- UTF-8 : 'é'
- Java Unicode = '\u00233'
Basically, a Unicode compatible ascii() function would be fine.
ascii('é') should return 233.
1) Has anyone written an ascii UTF-8 safe wrapper to ascii() function? If yes,
would you be so kind to publish this function on the list.
2) Are there plans to add an ascii() UTF-8 safe function to PostrgeSQL?
Best regards,
Jean-Michel POURE
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Patrice Hédé | 2002-05-19 09:44:13 | Re: [HACKERS] UTF-8 safe ascii() function |
| Previous Message | Niclas Gustafsson | 2002-05-17 10:54:00 | Indices for both where and order by. |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Wm. G. Urquhart | 2002-05-18 17:11:37 | Re: More on "What am I doing wrong!" |
| Previous Message | Doug Fields | 2002-05-18 16:40:43 | Re: Is there eny e-mail server that uses postgreSQL |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bear Giles | 2002-05-18 17:39:51 | SASL, compression? |
| Previous Message | Joel Burton | 2002-05-18 16:34:06 | Re: Updated CREATE FUNCTION syntax |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Nigel J. Andrews | 2002-05-18 18:11:40 | Re: [INTERFACES] libpgtcl - backend version information patch |
| Previous Message | Ed Schaller | 2002-05-17 21:54:18 | krb5 & multiple users |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Patrice Hédé | 2002-05-19 09:44:13 | Re: [HACKERS] UTF-8 safe ascii() function |
| Previous Message | pakorn | 2002-05-18 07:10:44 |