Unicode upper/lower solution proposal
Hi all,
Disclaimer: I'm not a C programmer and my knowledge of locales is
limited. I use Python.
PostgreSQL does not correctly use upper() and lower() for Unicode
characters. I've read the bug reports and followups at
archive.postgresql.org.
I'd like to propose two ideas:
1) Python has upper() and lower() functions, and they work in Unicode
perfectly. With Python being open source, could PostgreSQL developers
pick Python developer's brains? Is Python using only standard C library
calls to do its Unicode upper/lower conversion? Could the relevant part
of Python source code serve as a starting point of implementing Unicode
upper/lower in Postgres?
2) Arbitrary collation support for PostgreSQL is available at
http://www.fi.muni.cz/~adelton/l10n/ and it works perfectly. Could it be
used to implement Unicode upper/lower in Postgres?
--
Milos Prudek
Milos Prudek <prudek@bvx.cz> writes:
PostgreSQL does not correctly use upper() and lower() for Unicode
characters.
This is already fixed in CVS tip.
regards, tom lane
This is already fixed in CVS tip.
Oh, cool!
I know what is a CVS, but what is CVS tip?
In which PostgreSQL stable release is upper() and lower() for Unicode
planned to be included? Postgres version 7.5 ?
--
Milos Prudek
Milos Prudek wrote:
This is already fixed in CVS tip.
Oh, cool!
I know what is a CVS, but what is CVS tip?
In which PostgreSQL stable release is upper() and lower() for Unicode
planned to be included? Postgres version 7.5 ?
CVS tip is jus the current version of all CVS files. It means this will
be in 7.5.
--
Bruce Momjian | http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073