Subject Re: Firebird 2.0 and UNICODE
Author gsantosgo

My problem is SOLVED. The problem was, I am using SQL Hammer (now it
is called BlazeTOP), when i am doing SQL query on Firebird Database
with this software, the returned result doesn't know to display
Unicode Characters.

Then i used, a software is called JDBCTOOL (it is written in Java),
and i did the same SQL query and the result displays well Unicode
Characters. Then FIREBIRD 2.0 is working perfectly with Unicode

I put this in my code:

1. How is it Configuration Connection?
Driver driver = new org.firebirdsql.jdbc.FBDriver();
// Conexion a Base Datos
java.util.Properties connectionProperties = new java.util.Properties();
connectionProperties.put("user", "sysdba");
connectionProperties.put("password", "masterkey");
connectionProperties.put("charSet", "UTF-8");
Connection connection = driver.connect(databaseURL, connectionProperties)

2. How is it reading encoded UTF8 files in Java?

bufferedReader = new BufferedReader(new InputStreamReader(new

Thank you for everything.

--- In, Roman Rokytskyy <rrokytskyy@...>
> > At current, i use Firebird 2.0 and JayBird-2.1.1. My program analyzes
> > data files (*.txt) and it insert registers into firebird table.
> > Unicode admits characters from 0 to 65535 (2bytes, 16 bits), when my
> > program inserts a register with a Character Unicode greater than 800
> > (decimal value), Firebird doesn't understand properly.
> Did you specify the connection encoding? Can you provide your
example code?
> Roman