Subject Re: [Firebird-Java] How to set charset,SQL Dialect with FBManager!!!
Author Roman Rokytskyy
> I'm using Jaybird 2.0 and Firebird 1.5.2.I use service FBManager to create
> a new database by method createdatabase(String,String,String), but I find
> no way to set charset,SQL dialect for the new database.

It seems that Firebird ignores the DPB that is passed in the
isc_create_database call. You can change the SQL dialect by connecting to
the database with the isc_dpb_set_db_sql_dialect=1 connection property, it
will change the default dialect. In order to change the default character
set, you have to update the RDB$DATABASE table.

> I mean that how to set up a databaseparameterbuffer and pass it to
> FBManager .

We have tried this many times, but since it does not work, there is no
public method to set the DPB.

> And one more thing,when I execute a DDL statement like CREATE
> DATABASE...in Java using a connection of another database file,it always
> return error.Isthere any way to execute that sql statement?

Also does not work. This statement is used in isql and it uses
isc_dsql_execute_immediate, but again, so far I did not manage to make it
work in Jaybird. Neither in existing connection, nor in fresh one.

Roman