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