--- In firebird-support@yahoogroups.com, Helen Borrie <helebor@t...>
wrote:

> 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

The collation is set as default for the column. Even if I specify it
in the query, it doesn't help.

Thanks
Wenca