Greetings. In Interbase 6.X, I have created a database and table that
both use the SJIS_0208 character set as the default character set.
Metadata is below.

CREATE DATABASE 'sjis.gdb' DEFAULT CHARACTER SET SJIS_0208 */

CREATE TABLE "FOO"
(
"BAR" VARCHAR(30) CHARACTER SET SJIS_0208,
"BARBLOB" BLOB SUB_TYPE TEXT SEGMENT SIZE 80 CHARACTER SET SJIS_0208
);

I am trying to insert SJIS characters via JDBC; unfortunately, the
characters do not seem to be stored properly in the database when they
are inserted. I am using two JSP pages and one Java class to test the
process. The first page is a form that submits to the second page.
The second page first displays the form text it received, then inserts
into the database via my Java class, and then uses my Java class to
select the rows from the database and display them.

The SJIS characters entered into the form are rendered correctly by
the second JSP page. However, they do not seem to survive the
insertion and retrieval from the database. All I get is a question
mark or two for each SJIS character.

Do you have to specify the character set in JDBC to be SJIS? If so,
how? Do I need a specialized build of Interbase?

---
L. Cruz
Software Developer, PacketVideo