Hi,

I have got a table with the following definition:

CREATE TABLE T_DOKUMENTVORLAGEN (
NUMMER NUMERIC(18,0) NOT NULL,
DOKUMENTNAME VARCHAR(30) CHARACTER SET ISO8859_1 NOT NULL COLLATE
DE_DE,
DOKUMENTTYP VARCHAR(1) CHARACTER SET ISO8859_1 NOT NULL COLLATE
DE_DE,
DOKUMENT BLOB sub_type 0 segment size 8192);

I am using a TIB_DSQL to insert records.
When I am trying to insert a value for "Dokumentname"
which contains a German Umlaut (eg. äöü) I get the
following error: "Cannot transliterate character between character
sets".

I have learned that I have to change the Charset property of my
IB_Connection to ISO8859_1 so that it works.

Now my question is:
I have got an existing production database where all tables use the
charset NONE, but I would like to create some new tables with ISO8859_1.

So my question is: will an IB_Connection with its Charset set to
ISO8859_1
be able to work with the old tables or will errors occur?
Can a connection using ISO8859_1 read and write tables which are defined
as character set NONE?


TIA,

Christian