Sapdb ver 7.3.30
Using Oracle mode I encounter this problem (can be reproduced in sql
studio or jdbc)
CREATE TABLE test
(
JOBID number(6) NOT NULL,
datecolumn date,
MESSAGE long varchar,
PRIMARY KEY (JOBID)
)
insert into test values (347,null,'asdsadsadas') -works ok
insert into test values (347,TO_DATE('2003/09/30 10:53', 'YYYY/MM/DD
HH24:MI'),'asdsadsadas')
-fails -8006 data types must be compatible:MESSAGE
Why???
Regards,
Ajit
P.S. I prefer the old plain text format to the current mime mailing
format of the list. Can we change back??
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
