Subject Re: Unicode and Firebird2
Author mailmur
Be sure to use a proper jdbc-url parameters, and create database with
default UTF-8 charset (or per table/column).

Current FlameRobin UI client support utf8 texts as well, all you have
to do is select an unicode-aware font on query editor and table editor
panels. I use MS Arial Unicode font and all texts is displayed properly.


driver for standalone applications:

See here screenshots and examples.

Create new database through isql.exe:
* Run "{fb}\bin\isql.exe" commandline util to create a database
SQL> CREATE DATABASE 'c:\db\mydb.fdb'
user 'sysdba' password 'masterkey' DEFAULT CHARACTER UTF8;
SQL> SELECT * FROM rdb$database;

Or use FlameRobin UI Database/Create new Database command.

If you want to make sure whats db default charset, use "SELECT * FROM
rdb$database" query to see value.

--- In, "Steffen Heil" <lists@...> wrote:
> Hi
> Now, that firebird 2 is finally available (great work btw), I want
to switch
> from WIN1252/ISO8859_1 to UTF8 as soon as possible.
> Is there anything I need to check first? Any hitches or gotchas?
> My client software will be Java1.5/1.6 using JayBird 2.1 and
Firebird 2.0.
> Regards,
> Steffen