Subject Re: [Firebird-Java] UTF-8 to ISO-8859-2 conversion problems
Author Jerry
> 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.

Cast it as character set OCTETS or declare field in database as CHARACTER
SET OCTETS. OCTETS are able to store any string and it is represented as
sequence of bytes(binary data).