Subject | UTF-8 to ISO-8859-2 conversion problems |
---|---|
Author | Wenca |
Post date | 2004-09-15T18:44:49Z |
Hi all,
I'm parsing some XML files and I need to save content to my db. XML is
encoded in UTF-8 and my db is in ISO-8859-2. But if there is any
"special" character like éíášžčřö etc. it throws exception:
GDS Exception. 335544321. arithmetic exception, numeric overflow, or
string truncation
Cannot transliterate character between character sets
In connection URL I have:
jdbc:firebirdsql:local:data/xml_data.fdb?lc_ctype=UNICODE_FSS
If I don't specify any lc_ctype in URL, then these special characters
are corrupted (left in UTF).
But when the XML file is ISO-8859-2 encoded, everything runs OK, even if
I still have lc_ctype=UNICODE_FSS in my URL.
My configuration is:
Win XP
Java 1.5.0 beta2
Firebird 1.5.1.4481
JayBird 1.5.0
Can anyone help me?
Thanks a lot
Wenca
I'm parsing some XML files and I need to save content to my db. XML is
encoded in UTF-8 and my db is in ISO-8859-2. But if there is any
"special" character like éíášžčřö etc. it throws exception:
GDS Exception. 335544321. arithmetic exception, numeric overflow, or
string truncation
Cannot transliterate character between character sets
In connection URL I have:
jdbc:firebirdsql:local:data/xml_data.fdb?lc_ctype=UNICODE_FSS
If I don't specify any lc_ctype in URL, then these special characters
are corrupted (left in UTF).
But when the XML file is ISO-8859-2 encoded, everything runs OK, even if
I still have lc_ctype=UNICODE_FSS in my URL.
My configuration is:
Win XP
Java 1.5.0 beta2
Firebird 1.5.1.4481
JayBird 1.5.0
Can anyone help me?
Thanks a lot
Wenca