Subject Re: Special unicode characters in connection string problem
Author venushau
This is OK now when I try with another parameter "encoding" and set
it to "UNICODE_FSS".

--- In Firebird-Java@yahoogroups.com, "venushau" <venushau@...> wrote:
>
> 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
> >
>