Subject Re: ORDER BY and Unicode field
Author peter_jacobi.rm
--- "d_dude_2003" <d_dude_2003@y...> wrote:
> I created my FB 1.5 database with UNICODE_FSS charset.
> 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?

That depends on your value of "properly". Currently
the only available option is Unicode codepoint order,
which may or may not be OK for you.

> Also, will queries like WHERE UNICODEFIELD = UNICODEVALUE
> work?

Also depends on your expectations?

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