inoffensive_2006 wrote:

> Hi Folks:
>
> I'm using Firebird 2.0.1 and IBPP.
>
> Is there a simple way to define a collation sequence?
>
> This would be for English language.
>
> I'd like all non alpha-numeric first, followed by
> numbers, then case insensitive alphas.
>
> I see references to specifying particular character
> sets to a field, but is there a way to just plop some
> characters into a user built table and telling Firebird
> that's how I want indexes to this field to be sorted?
>
> I have a feeling the answer is "No", so what is the
> character set for case insensitive English? What does
> that do with the 6 non-alpha characters between the
> upper and lower case alphas?
>
> Thanks
> Larry
>
>
>

Larry,

Give a try to collation PT_BR for character set ISO8859_1 or WIN_PTBR
for charset Win1252

see you !

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