BUG #1153: to_ascii() doesn't work on eth ()

Lists: Postg토토 꽁 머니SQL : Postg토토 꽁 머니SQL 메일 링리스트 : 2004-05-12 이후 PGSQL-BUGS 17:37
From: "PostgreSQL Bugs List" <pgsql-bugs(at)postgresql(dot)org>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #1153: to_ascii() doesn't work on eth ()
Date: 2004-05-12 17:37:33
Message-ID: 20040512173733.B4748CF573C@www.postgresql.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: Postg토토 꽁 머니SQL : Postg토토 꽁 머니SQL 메일 링리스트 : 2004-05-12 이후 PGSQL-BUGS 17:37


The following bug has been logged online:

Bug reference: 1153
Logged by: Peter of the Norse

Email address: RahmCoff(at)Radio1190(dot)org

PostgreSQL version: 7.3.4

Operating system: Linux

Description: to_ascii() doesn't work on eth ()

Details:

I use to_ascii() to deal with the fact that we have American keyboards but
must deal with various languages. It works great, but for the occational
icelandic word with in it. Currently to_ascii changes all 's to spaces,
which breaks everything. I understand that it's usually translated as 'th',
but 'd' is a much more common substitution.


From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Peter of the Norse" <RahmCoff(at)Radio1190(dot)org>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #1153: to_ascii() doesn't work on eth ( )
Date: 2004-05-12 18:58:37
Message-ID: 27425.1084388317@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-bugs

"PostgreSQL Bugs List" <pgsql-bugs(at)postgresql(dot)org> writes:
> Currently to_ascii changes all 's to spaces,
> which breaks everything.

The present to_ascii() code isn't very bright ... it doesn't know about
very many encodings, and it can't handle length-changing edits, which
is what you seem to need. Want to improve it and send a patch? See
src/backend/utils/adt/ascii.c.

regards, tom lane