Subject Simple Definition of Collation Sequence?
Author inoffensive_2006
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?