Skip site navigation (1) Skip section navigation (2)

UTF-8 safe ascii() function

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 (view raw or flat)
Thread:
Lists: pgsql-adminpgsql-generalpgsql-hackerspgsql-interfacespgsql-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

Responses

pgsql-odbc by date

Next:From: Patrice HédéDate: 2002-05-19 09:44:13
Subject: Re: [HACKERS] UTF-8 safe ascii() function
Previous:From: pakornDate: 2002-05-18 07:10:44
Subject:

pgsql-hackers by date

Next:From: Bear GilesDate: 2002-05-18 17:39:51
Subject: SASL, compression?
Previous:From: Joel BurtonDate: 2002-05-18 16:34:06
Subject: Re: Updated CREATE FUNCTION syntax

pgsql-admin by date

Next:From: Patrice HédéDate: 2002-05-19 09:44:13
Subject: Re: [HACKERS] UTF-8 safe ascii() function
Previous:From: Niclas GustafssonDate: 2002-05-17 10:54:00
Subject: Indices for both where and order by.

pgsql-interfaces by date

Next:From: Nigel J. AndrewsDate: 2002-05-18 18:11:40
Subject: Re: [INTERFACES] libpgtcl - backend version information patch
Previous:From: Ed SchallerDate: 2002-05-17 21:54:18
Subject: krb5 & multiple users

pgsql-general by date

Next:From: Wm. G. UrquhartDate: 2002-05-18 17:11:37
Subject: Re: More on "What am I doing wrong!"
Previous:From: Doug FieldsDate: 2002-05-18 16:40:43
Subject: Re: Is there eny e-mail server that uses postgreSQL

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group