Subject | Re: UTF8 question |
---|---|
Author | mailmur |
Post date | 2006-11-20T11:57:29Z |
> HiCould you test insert sql using my test UI program (jdbctool.zip).
> I am using Jaybird 2.1 with Firebird 2.0 and I do the following:
> statement.addBatch( "INSERT INTO TEST (NAME) VALUES ('Löschen')" );
> And I get "Malformed String".
> Why?
>
> Connection has:
> encoding=UTF8
> charSet=utf-8
> Field has:
> charset=UTF8
> collation=UTF8
>
> BTW: Java source is writen in utf-8.
Type in the INSERT sql and run it. Then run SELECT query to see results.
http://koti.mbnet.fi/akini/fb/
What if you remove charset from url and use something like this:
jdbc:firebirdsql:localhost/3050:c:/db/mydb.fdb?encoding=UTF8&user=myid&passwor
d=mypwd
I dont know about addBatch command, never used if it creates
additional quirks.