Page 1 of 1

CREATE TABLE TEXT(65535) error

Posted: Mon Sep 22, 2003 1:51 pm
by kendall
Hello,

i am trying to create a table with a

Code: Select all

ALTER TABLE online_classifieds MODIFY Description blob(65535) NOT NULL
is there any reason why i would get a
You have an error in your SQL syntax near '(65535) NOT NULL ' at line 1
Kendall

Posted: Tue Sep 23, 2003 3:27 am
by twigletmac
Try running the change without the size definition for the blob, IIRC, that is not needed for BLOBs.

Mac

Posted: Tue Sep 23, 2003 8:18 am
by kendall
Twiglet,

I did that as well too and it got a syntax saying i need to specify a length

Kendall

Posted: Tue Sep 23, 2003 8:34 am
by twigletmac
That's really strange, I ran a test on a table of my own just to check and

Code: Select all

ALTER TABLE results_answers MODIFY question_id blob NOT NULL
worked fine, however,

Code: Select all

ALTER TABLE results_answers MODIFY question_id blob(65535) NOT NULL
gave the same error you initially posted.

Mac