Subject Re: [firebird-support] Derived collations?
Author Alexandre Benson Smith
Richard Wesley wrote:
> Is it possible to convince FB to use collations in a case (or accent)
> insensitive manner? I noticed that there is a new column called "RDB
> $BASE_COLLATION_NAME" and I was wondering if I could add a new
> collation that references an existing one but sets the RDB
> $COLLATION_ATTRIBUTE bits to e.g. 7. I suspect not as I see things
> like "ES_ES_CI_AI" being built explicitly, but it is a real PITA to
> have to put UPPER and MIN in everywhere I want CI collation. Is
> there a good solution to this problem that does not require
> rebuilding every collation into a new DLL?
>
> TIA
> ________________________________________________________
> Richard Wesley Senior Software Developer Tableau
> Software
> Visit: http://www.trytableau.com/now.html
>

Richard,

Try collation PT_BR on charset ISO8859_1 or WIN_PTBR on charset WIN1252

see you !

--
Alexandre Benson Smith
Development
THOR Software e Comercial Ltda
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br