Skip site navigation (1) Skip section navigation (2)

Re: Case Conversion Fix for MB Chars

From: Volkan YAZICI <volkan(dot)yazici(at)gmail(dot)com>
To: pgsql-patches(at)postgresql(dot)org
Subject: Re: Case Conversion Fix for MB Chars
Date: 2005-11-27 12:12:14
Message-ID: 7104a7370511270412q1d252ab2pdf90d446f1d89a87@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-patchespgsql-tr-genel
[Sorry if the post is duplicated. But I don't receive and ACK from majordamo.]

On 11/27/05, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> Doesn't this just move the failure cases around?

I don't think so. I've tried to fix every tolower/toupper related
problem (depending on the MB characters) I found in the code. If
there's still a problem with them, it should be related with the
pg_wchar_tb concept in utils/mb/wchar.c (AFAIC, the last remaning part
about this case conversion mess is the one related with PQfnumber -
which needs a very different approach.)

> The really fundamental problem is that tolower/toupper don't work
> on wchar_t.

Yes, indeed. I agree with you to find a proper solution for character
set handling. But, IMHO, it's better to have a-patchy working system
instead of a not working one. Put yourself in our position, we're
trying to give enterprise solutions to our customers and ILIKE,
lower/upper doesn't work in the product that we support. We can work
with a small patch instead of waiting next releases for an exact
solution to the problem.

In response to

Responses

pgsql-tr-genel by date

Next:From: Timu ERENDate: 2005-11-27 12:24:17
Subject: Veri özeti?=, Like ile arama =?utf-8?q?performans'ı
Previous:From: Volkan YAZICIDate: 2005-11-27 10:58:47
Subject: Re: [PATCHES] Case Conversion Fix for MB Chars

pgsql-patches by date

Next:From: Christopher Kings-LynneDate: 2005-11-27 15:15:04
Subject: Strange interval arithmetic
Previous:From: Volkan YAZICIDate: 2005-11-27 10:58:47
Subject: Re: [PATCHES] Case Conversion Fix for MB Chars

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group