Hello all,
I'll try to ask my problem again. I just want to know if it is bug or a
wanted behavior of MaxDB, and if why. So, please somebody help.
I'm trying to create a table with a LONG VARCHAR field and fill it with
data. I'm using MaxDB 7.5.00.14. I'm connected to DB using Oracle SQL
mode in SQL Studio.
CREATE TABLE testTable1( textfield LONG VARCHAR, datefield DATE)
INSERT INTO testTable1 (textfield ,datefield) VALUES
('Test',TO_DATE('04/27/2000 12:00:00','MM/DD/YYYY 24:MI:SS'))
---- Error -------------------------------
Auto Commit: On, SQL Mode: Oracle, Isolation Level: Committed Integrity
constraint violation;-8006 POS(1) Data types must be
compatible:TEXTFIELD.
The next statement works? Why not the other? For me they look the same.
INSERT INTO testTable1 (textfield ,datefield) VALUES
('Test',SYSDATE)
Thanx in advance.
Greets
Mathias
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
