Backported the very useful oracle_compat.c from postgres 8.0 beta to 7.4.5

From: Johannes Weberhofer <postgres(at)weberhofer(dot)at>
To: pgsql-patches(at)postgresql(dot)org
Subject: Backported the very useful oracle_compat.c from postgres 8.0 beta to 7.4.5
Date: 2004-08-26 15:31:06
Message-ID: 412E023A.3010207@weberhofer.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-patches

Dear all!

I'm new to the list, so please excuse if I repost this patch.

In the found the _very_ useful oracle_compat.c function which implements
correct UPPER(), LOWER() and INITCAP() for multibyte charactersets.

This change is very important for everyone who uses multilingual
databases, because it makes case insensitive search possible (like
"Ärzte" and "ärzte"). We have tested the patch in our work, and we did
not see any problems so far. I think Postgres without that patch is buggy.

Thank you to Tom (who wrote the code) for the great work.

The attached patch will patch the current stable version 7.4.5

Best whishes,

Johannes

Attachment Content-Type Size
postgresql-upperLowerMultibytePatch.diff text/plain 10.3 KB

Browse pgsql-patches by date

  From Date Subject
Next Message Dave Page 2004-08-26 16:11:48 Re: [PATCHES] postmaster.pid
Previous Message Tom Lane 2004-08-26 15:23:39 Re: [PATCHES] postmaster.pid