Subject Re: [firebird-support] Simple Definition of Collation Sequence?
Author Alexandre Benson Smith
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


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

see you !

Alexandre Benson Smith
THOR Software e Comercial Ltda
Santo Andre - Sao Paulo - Brazil