Subject | Re: Firebird 2.0 and UNICODE |
---|---|
Author | gsantosgo |
Post date | 2007-02-22T10:05:57Z |
Hello.
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
Characters.
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");
//connectionProperties.put("encoding","UTF8");
Connection connection = driver.connect(databaseURL, connectionProperties)
2. How is it reading encoded UTF8 files in Java?
bufferedReader = new BufferedReader(new InputStreamReader(new
FileInputStream(absolutePath),"UTF-8"));
Thank you for everything.
Guillermo
--- In Firebird-Java@yahoogroups.com, Roman Rokytskyy <rrokytskyy@...>
wrote:
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
Characters.
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");
//connectionProperties.put("encoding","UTF8");
Connection connection = driver.connect(databaseURL, connectionProperties)
2. How is it reading encoded UTF8 files in Java?
bufferedReader = new BufferedReader(new InputStreamReader(new
FileInputStream(absolutePath),"UTF-8"));
Thank you for everything.
Guillermo
--- In Firebird-Java@yahoogroups.com, Roman Rokytskyy <rrokytskyy@...>
wrote:
>example code?
> > 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
>
> Roman
>