Hi,

> I just installed IBPhonix and JCA-JDBC. I didn't change anything.
> So I think DB should be NONE.

Charset is specified on database or table creation: "CREATE
DATABASE ... DEFAULT CHARACTER SET ..." or "CREATE TABLE ...(col1
VARCHAR(50) CHARACTER SET .., ...)". If you did not use such DDL
statements, then your database uses NONE.

> OK! I tried to set lc_ctype=NONE. But that still leads to the same
> result, the same exception. I deleted all rows from my table,
> filled them and read them having lc_ctype=NONE.

That is strange. Can you send me your program (or prepare small test
case that reproduces this error) with your database metadata?

> I know this is the wrong newsGroup but can you please tell me how
> to change the character encoding from Firebird. I found nothing
> yet about that topic in the documentation.

You cannot change default encoding of the database after creation.
But you can change encodings of particular tables using:

ALTER TABLE a_table ALTER COLUMN a_col TYPE VARCHAR(...) CHARACTER
SET WIN1252;

(That's what Language Reference says, I didn't try by myself, it
might contain mistakes)

> Could it be that I have to download a newer Version of JCA-JDBC? I
> saw some postings which sais that there are made some changes in
> character encoding since Beta 1.

Yes, you definitely need! If you do not have CVS access, you can
download CVS snapshot I made yesterday from
http://groups.yahoo.com/group/Firebird-Java/files/client-
java_snapshot_20020527.zip

> By the way, why is there no exception using Interclient? Having
> problems with my character coding doesn't Interclient have to have
> the same problems?

I do not remember exactly when we introduced lc_ctype, it might be
that after beta1.

Best regards,
Roman