Subject | Character Sets & Accessing Firebird using Jaybird |
---|---|
Author | agarzotto |
Post date | 2004-06-04T13:28:50Z |
We have a rather large Firebird database that was created a long time
ago (as an Interbase DB) using character set "NONE". We use it from
Java 1.4.2. by means of Interclient. The data in there is actually ISO
8859-1 (but the DB does not know about it).
We want to replace Interclient by Jaybird, but did run into a problem
with the character sets. When connecting using character set "NONE",
we can read and write, but any non-ASCII character seems to be ignored
(replaced by "?"). When we indicate ISO8859_1, it tries to convert,
which of course fails.
What can we do to achieve 8-bit transparent access to the DB using
Jaybird? Or is there a different approach that we could try?
Regards,
Andreas
ago (as an Interbase DB) using character set "NONE". We use it from
Java 1.4.2. by means of Interclient. The data in there is actually ISO
8859-1 (but the DB does not know about it).
We want to replace Interclient by Jaybird, but did run into a problem
with the character sets. When connecting using character set "NONE",
we can read and write, but any non-ASCII character seems to be ignored
(replaced by "?"). When we indicate ISO8859_1, it tries to convert,
which of course fails.
What can we do to achieve 8-bit transparent access to the DB using
Jaybird? Or is there a different approach that we could try?
Regards,
Andreas