[HACKERS] 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 ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings
Re: [HACKERS] Unicode upper/lower solution proposal
Milos Prudek [EMAIL PROTECTED] writes: PostgreSQL does not correctly use upper() and lower() for Unicode characters. This is already fixed in CVS tip. regards, tom lane ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
Re: [HACKERS] Unicode upper/lower solution proposal
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 ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
Re: [HACKERS] Unicode upper/lower solution proposal
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 [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup.| Newtown Square, Pennsylvania 19073 ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings