Subject Re: Special unicode characters in connection string problem
Author venushau
Thanks a lot for fixing the problem.
I can be able to connect an .fdb file with unicode characters in the
connection string now, with the use of Jaybird 2.1.0 RC1.

By the way, I've faced another problem in the new Jaybird version.
In the connection string, I've tried to set the charSet property to
UTF-8 as usual.
An exception is thrown:

org.firebirdsql.jdbc.FBSQLException: GDS Exception. 335544325. bad
parameters on attach or create database CHARACTER SET UTF8 is not
defined
Reason: bad parameters on attach or create database
CHARACTER SET UTF8 is not defined
at org.firebirdsql.jdbc.FBDataSource.getConnection
(FBDataSource.java:122)
at org.firebirdsql.jdbc.FBDriver.connect(FBDriver.java:131)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at test.firebird.TestFBConnection.getConnection
(TestFBConnection.java:162)
at test.firebird.TestFBConnection.getConnection
(TestFBConnection.java:95)
at test.firebird.TestFBConnection.main
(TestFBConnection.java:42)
at org.firebirdsql.gds.GDSException: bad parameters on attach or
create database
CHARACTER SET UTF8 is not defined
at
org.firebirdsql.gds.impl.jni.JniGDSImpl.native_isc_attach_database
(Native Method)
at org.firebirdsql.gds.impl.jni.BaseGDSImpl.iscAttachDatabase
(BaseGDSImpl.java:135)
at org.firebirdsql.jca.FBManagedConnection.<init>
(FBManagedConnection.java:89)
at
org.firebirdsql.jca.FBManagedConnectionFactory.createManagedConnection
(FBManagedConnectionFactory.java:470)
at
org.firebirdsql.jca.FBStandAloneConnectionManager.allocateConnection
(FBStandAloneConnectionManager.java:69)
at org.firebirdsql.jdbc.FBDataSource.getConnection
(FBDataSource.java:119)
at org.firebirdsql.jdbc.FBDriver.connect(FBDriver.java:131)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at test.firebird.TestFBConnection.getConnection
(TestFBConnection.java:162)
at test.firebird.TestFBConnection.getConnection
(TestFBConnection.java:95)
at test.firebird.TestFBConnection.main
(TestFBConnection.java:42)
java.lang.NullPointerException
at test.firebird.TestFBConnection.main
(TestFBConnection.java:42)

------------------------------------------------------

It works when I was using Jaybird 2 earlier builds with the same
Firebird version.
Is there changes made in setting the character set?
Or is there some other ways that can help to overcome this problem?

Thanks a lot.



--- In Firebird-Java@yahoogroups.com, "Roman Rokytskyy"
<rrokytskyy@...> wrote:
>
> > The problem occurs on a client machine, probably with regional
> > settings to Germany.
> >
> > However, this problem also occurs on my machine (OS is Windows XP,
> > same for the client machine),
> > with a regional settings to English (United States).
> >
> > This happens in Windows XP, with regional settings to English
(United
> > States).
>
> I think I have found the issue... our JNI part tries to obtain file
name as
> UTF characters, but Firebird expects just "normal" ones.
>
> The fix is trivial, but it affects the jaybird21.dll, I will have
to check
> how to manage it better from the compatibility POV.
>
> Roman
>