Re: [Firebird-devel] Case-insensitive collations

[Peter J. <pj...@wa...>]

Hi Carlos,

"Carlos H. Cantu" <fb...@wa...> wrote:

> Initial tests with ISO8859_NCNA were sucessfull! The only problem is
> that STARTING WITH and CONTAINING doesnt work with it. 

As I never miss to mention, as a workaround for STARTING WITH
 you can use BETWEEN 'foobar' AND 'foobarzzz'.

> I guess that is
> the reason why Paulo (the Brazilian guy who created PT_BR) had to
> modify the executables of Firebird to make it work with SW and
> CONTAINING.

The STARTING WITH and LIKE 'foo%' case is a nearly trivial patch, which
was discussed some hours ago.

CONTAINING and the general LIKE case would need some additional work.

Also it seems that the codebase of Firebird 1.5 and CVS HEAD have already 
diverged siginificantly, so that it's a tough choice, which version to 
address.

> So I think the collations could me merged, but together with that, we
> would need code changes to make Starting With and Containing working
> with them.

You are now at the point, were you have to either:
- start working on this
- motivate someone to work on this
OR
- pay someone to work on this

> Also a collation NCNA for WIN1252 would be apreciated (it can be based
> on PXW_INTL850).

The LOADABLE collation in my pjcolkit is called LOADABLE, because you can 
tailor it yourself to any charset and collation by creating one data file.

Regards,
Peter Jacobi