>
> Hi Sean,
>
> FB 2.0 has support for case insensitive collations I use a
> collation named PT_BR that is case/accent insensitive.
>
> This collation come from a brazilian "fork" of FB, in truth,
> it is not a fork, it is just the same FB code with this
> collation implemented.
>
> If you wish you could try it (it is stable and I run it for
> some years)
>
> www.sourceforge.net/projects/firebirdptbr
>
> a sample will be like this:
> create Table MyTest(Name varchar(40) charset iso8859_1 collate PT_BR);
>
> create index idx_Name on MyTest(name);
>
> commit;
>
> insert into MyTest values ('aBc');
> insert into MyTest values ('Ábç'');
> insert into MyTest values ('ãBC');
> insert into MyTest values ('àbc');
> insert into MyTest values ('ÃbC');
> insert into MyTest values (''ÄBÇ');
> insert into MyTest values ('ABC');
> commit;
>
> all the bellow queries will return all records with indexed reads:
> select * from MyTeste where Name = 'abc'
> select * from MyTeste where Name = 'ábç'
> select * from MyTeste where Name like 'A%'
> select * from MyTeste where Name like 'á%'
>
> see you !
>
> --
> Alexandre Benson Smith
> Development
> THOR Software e Comercial Ltda
> Santo Andre - Sao Paulo - Brazil
> www.thorsoftware.com.br
>
>

Thanks. I will have a look at it. Are there any other case insensitive
collations in 2?


Regards

Sean
---------------------------------------
Sean Cross
mailto:sean@...

Pics Print - The photo printing solution for Windows.
http://www.picsprint.com

Rental Property Manager: Rental management made easy
http://www.sourceitsoftware.com