Can someone please confirm whether Derby support ORDER BY for Arabic?

[sarah.kho]

Hi
Can someone pelase confirm that Derby can sort Arabic text correctly?
I have a table and I can not get the data in correct order using the order by command.

Thanks

[Knut Anders Hatlen]

"sarah.kho" <sarah.kho@...> writes:

> Hi
> Can someone pelase confirm that Derby can sort Arabic text correctly?
> I have a table and I can not get the data in correct order using the order
> by command.

Hi Sarah,

I cannot confirm that it works correctly with Arabic text, as I've never
tried, but I was under the impression that it was supposed to work. Did
you create your database with territory-based collation and an Arabic
locale?

http://db.apache.org/derby/docs/10.5/devguide/tdevdvlpcollation.html
http://db.apache.org/derby/docs/10.5/ref/rrefattribcollation.html

--
Knut Anders