Subject | Re: Unicode and Firebird2 |
---|---|
Author | mailmur |
Post date | 2006-11-18T19:18:54Z |
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.
url:
jdbc:firebirdsql:localhost/3050:c:/db/mydb.fdb?encoding=UTF8&user=sysdba&password=masterkey
driver for standalone applications:
org.firebirdsql.jdbc.FBDriver
See here screenshots and examples.
http://koti.mbnet.fi/akini/fb/
http://koti.mbnet.fi/akini/fb/flamerobin.html
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;
SQL> QUIT;
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.
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.
url:
jdbc:firebirdsql:localhost/3050:c:/db/mydb.fdb?encoding=UTF8&user=sysdba&password=masterkey
driver for standalone applications:
org.firebirdsql.jdbc.FBDriver
See here screenshots and examples.
http://koti.mbnet.fi/akini/fb/
http://koti.mbnet.fi/akini/fb/flamerobin.html
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;
SQL> QUIT;
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 Firebird-Java@yahoogroups.com, "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