Subject | Re: ORDER BY and Unicode field |
---|---|
Author | peter_jacobi.rm |
Post date | 2004-04-14T12:41:28Z |
--- "d_dude_2003" <d_dude_2003@y...> wrote:
the only available option is Unicode codepoint order,
which may or may not be OK for you.
If you are asking whether FB will detect canonical
equivalence, e.g.
U+013E == U+006C U+030C
Then the answer is no.
Regards,
Peter Jacobi
> I created my FB 1.5 database with UNICODE_FSS charset.That depends on your value of "properly". Currently
> All varchar fields are created automatically with this charset as
> well. What else i need to ensure to have ORDER BY clause working
> properly for string field containing UNICODE?
the only available option is Unicode codepoint order,
which may or may not be OK for you.
> Also, will queries like WHERE UNICODEFIELD = UNICODEVALUEAlso depends on your expectations?
> work?
If you are asking whether FB will detect canonical
equivalence, e.g.
U+013E == U+006C U+030C
Then the answer is no.
Regards,
Peter Jacobi