Nando Dessena wrote:

> Hello,
>
>
>>>>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.
>
>
> you need to distribute the intl directory and the fbintl.dll together
> with fbembed.dll if you want to use that charset and collation.
> Read the docs.
>
> Ciao

When I specify the character coding in the connection URL:
jdbc:firebirdsql:embedded:data/DATA.FDB?lc_ctype=WIN1250

I get this exception when trying to connect:

Unable to establish a connection through the driver manager.
org.firebirdsql.jdbc.FBSQLException: Resource Exception. bad parameters
on attach or create database
CHARACTER SET WIN1250 is not defined
Reason: bad parameters on attach or create database
CHARACTER SET WIN1250 is not defined

I put all the files from the distribution to the dir with my app as
described in doc/README_embedded.txt but nothing helps.

Thanks
Wenca