Subject | Sorting national characters in Firebird |
---|---|
Author | lmar2201 |
Post date | 2004-11-05T08:21:11Z |
My question is how to sort column according to my national letters
(accented).
In details:
I am using Firebird 1.5.1, Win32 build.
My database is using UNICODE_FSS codepage for representing character
strings.
I need sort some columns according to sorting rules given by our
national standard organisation (namely Czech one).
Unfortunately I do not know about any possibility how to do it. There
is no collation order for UNICODE_FSS.
So:
Is there any direct method (i.e. supported directly by SQL) how to
force Firebird to sort according to my rules?
Is there any idea how to do it programmaticaly? Some UDF?
Or must be there some changes directly to FireBird? Can I contribute
somehow to solve this?
Thank you for hints.
Ludek Marek
(accented).
In details:
I am using Firebird 1.5.1, Win32 build.
My database is using UNICODE_FSS codepage for representing character
strings.
I need sort some columns according to sorting rules given by our
national standard organisation (namely Czech one).
Unfortunately I do not know about any possibility how to do it. There
is no collation order for UNICODE_FSS.
So:
Is there any direct method (i.e. supported directly by SQL) how to
force Firebird to sort according to my rules?
Is there any idea how to do it programmaticaly? Some UDF?
Or must be there some changes directly to FireBird? Can I contribute
somehow to solve this?
Thank you for hints.
Ludek Marek