Character Set and Collation are both set to NONE.

-Shaq

--- In firebird-support@yahoogroups.com, "Thomas Steinmaurer"
<ts@i...> wrote:

> Shaq,
>
> > If I have uppercase and lowercase names and I select all and

order

> > by name. It will not sort the uppercase and lowercase names
> > properly. For example I get back:
> >
> > ADAMO APRIL
> > ANDERSON MARIELLEN
> > Abreu Jonathon
> > Aiello James
> > Allande Faith
> >
> > I'm not sure what to change to get the correct alphabetical

order in

> > this scenario.
>
> It's a matter of using the correct collation for your
> choosen character set.
>
> What character set and collation was the character
> field created with?
>
>
> Best Regards,
> Thomas Steinmaurer
> LogManager Serie - Logging/Auditing Suites supporting
> InterBase, Firebird, Advantage Database and MS SQL Server
> Upscene Productions
> http://www.upscene.com