Difference between CHAR datatype in SqlBase and Oracle

We want to convert our SqlBase database to an Oracle database.We have our Sqlbase schema created in ERwin. When you change the target server in the schema a char field in SqlBase is changed into a char field in Oracle.
Eg. :

CREATE TABLE SqlBase : CREATE TABLE TEST (field1 char(10)) Oracle : CREATE TABLE TEST (field1 char(10))

INSERT INTO THE TABLE INSERT INTO TEST values ('1234');

LENGTH SqlBase : LENGTH : 4
Oracle : LENGTH : 10

SqlBase : select * from test where field1 = '1234' ==> 1 row found Oracle : select * from test where field1 = '1234' ==> 0 rows found

If I change my datatype in Oracle into VARCHAR(10) it works fine. Is that the only solution ?

Thanks for the answers,

Franky Received on Tue Oct 23 2001 - 14:45:16 CEST