Subject Re: Character set and order by
Author peter_jacobi.rm
Hi Primoz,

--- In firebird-support@yahoogroups.com, "Planles" wrote:
> I use win1250 character set (central european), but the collation
with ORDER
> BY doesn't work properly. Our special characters are not listed
> alphabetically thi right way.
>
> What all is neccesary to set up, that I will get the right
alphabetically,
> considerating our special characters ?

The character set doesn't specify the sort order, the collation does.
Look into the docs which collation fits your needs and add a COLLATE
clause to the column definition.

Regards,
Peter Jacobi