At 02:31 PM 23/11/2004 +0000, you wrote:

> > >
> > >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 ?
> >
>
>The collation is set as default for the column. Even if I specify it
>in the query, it doesn't help.

Are you using the correct character set parameter (lc_ctype) in the client
connection ?

./hb