Subject | Re: Character set and order by |
---|---|
Author | peter_jacobi.rm |
Post date | 2004-08-07T13:04:50Z |
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