Subject Re: bad news about encoding...
Author Ardhivipala Gunawijaya
Post date 2002-05-17T11:18:42Z
Hi All,
 
I'am beginner in Firebird-Java group.
I have problem in create SQL script for unicode,
can someone help, and give me sample code.
 
for example, I want to do this:
 
INSERT INTO TEST (UNICODE_FSS_FIELD) VALUES ('碼/標準萬國')
or
INSERT INTO TEST (UNICODE_FSS_FIELD) VALUES (' هي الشفرة الموحدة يونِكود )
 
Please, I need help
 
thanks and regards,
 
Ardhi
 
 
 

--- In Firebird-Java@y..., Marczisovszky Daniel <marczi@d...> wrote:
> Sorry, none of these works.
>
> daniel
>
>
> Properties properties = new Properties ();
>
properties.put("user", "sysdba");
> properties.put("password",
"masterkey");
> properties.put("lc_ctype", "UNICODE_FSS");
>
> // First
>
> con =
DriverManager.getConnection("jdbc:firebirdsql:localhost/3050:/develop/test.gdb", properties);
> PreparedStatement stmt = con.prepareStatement("insert into
test (win1250field) values (?)");
> stmt.setString(1,
"\u0151rült");
> stmt.executeUpdate();
>
> // Second
>
> con =
DriverManager.getConnection("jdbc:firebirdsql:localhost/3050:/develop/test.gdb", properties);
> PreparedStatement stmt = con.prepareStatement("insert into
test (win1250field) values (?)");
> stmt.setString(1, "õrült");
>
stmt.executeUpdate();
 
 
__________________________________________________________________
Ardhivipala Gunawijaya
ICQ#: 76732552
Current ICQ status:  
+  More ways to contact me
i  See more about me:
__________________________________________________________________