Oracle Database Discussions

I am experiencing something that goes over my knowledge. We have done database testing for both ZHT16BIG5 and western char set in Oracle 8i. In western char set, no problems. the test goes perfect.

With ZHT16BIG5 inserting of the tables fail. Below you'll find the log from the test:


Performing blob and character tests:
The comparing on table with fields:

FIELD0 LONG, FIELD1 BLOB, FIELD2 VARCHAR2(255)
after INSERT failed on the following fields:
FIELD0 LONG, FIELD2 VARCHAR2(255).

The comparing on table with fields:
FIELD0 LONG, FIELD1 BLOB, FIELD2 VARCHAR2(255)
after UPDATE failed on the following fields:
FIELD0 LONG.

The comparing on table with fields:
FIELD0 VARCHAR2(2000), FIELD1 BLOB, FIELD2 BLOB
after INSERT failed on the following fields:
FIELD0 VARCHAR2(2000).

The comparing on table with fields:
FIELD0 VARCHAR2(2000), FIELD1 BLOB, FIELD2 BLOB
after UPDATE failed on the following fields:
FIELD0 VARCHAR2(2000).

The comparing on table with fields:
FIELD0 VARCHAR2(2000), FIELD1 LONG RAW , FIELD2 VARCHAR2(255)
after INSERT failed on the following fields:
FIELD0 VARCHAR2(2000), FIELD2 VARCHAR2(255).

The comparing on table with fields:
FIELD0 VARCHAR2(2000), FIELD1 LONG RAW , FIELD2 VARCHAR2(255)
after UPDATE failed on the following fields:
FIELD0 VARCHAR2(2000).

The comparing on table with fields:
FIELD0 VARCHAR2(255), FIELD1 VARCHAR2(255)
after INSERT failed on the following fields:
FIELD0 VARCHAR2(255), FIELD1 VARCHAR2(255).

Can't insert to table with fields:
FIELD0 VARCHAR2(1800), FIELD1 VARCHAR2(2000), FIELD2 VARCHAR2(2000), FIELD3 LONG
("Exception: CODBCQueryCODBCQuery.ExecSQL, SQLExecDirect: HY000: [Oracle][ODBC][Ora]ORA-01461: can bind a LONG value only for insert into a LONG column
" exception).

Failed tests: 11.


I really would appriciate some advises.

If you have any Ideas, you can send them to my email:

Jarkko.pelli@qpr.com

Thank you.