At 02:06 PM 23/11/2004 +0100, you wrote:

>Hi all,
>
>I want to use the embedded server in my java application but I found
>a problem, that I'm not able to solve.
>
>The connection to the embedded server is OK, when I run a simple query
>like SELECT * FROM SOME_TABLE it is OK too. But when I add an ORDER BY
>clause to my query it freezes immediately with no exception and I have
>to stop the thread manualy. The same problem is when I use a SUBSTRING()
>function and maybe somewhere else.
>
>Maybe it's caused by WIN1250 chracter set or by PXW_CSY collation
>because when I tried to use the example database EMPLOYEE.FDB from
>firebird distribution everything works fine.

Do you specify ..ORDER BY AField COLLATE PXW_CSY ?

./hb