CREATE TABLE TEXT(65535) error

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
User avatar
kendall
Forum Regular
Posts: 852
Joined: Tue Jul 30, 2002 10:21 am
Location: Trinidad, West Indies
Contact:

CREATE TABLE TEXT(65535) error

Post 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
User avatar
twigletmac
Her Royal Site Adminness
Posts: 5371
Joined: Tue Apr 23, 2002 2:21 am
Location: Essex, UK

Post by twigletmac »

Try running the change without the size definition for the blob, IIRC, that is not needed for BLOBs.

Mac
User avatar
kendall
Forum Regular
Posts: 852
Joined: Tue Jul 30, 2002 10:21 am
Location: Trinidad, West Indies
Contact:

Post by kendall »

Twiglet,

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

Kendall
User avatar
twigletmac
Her Royal Site Adminness
Posts: 5371
Joined: Tue Apr 23, 2002 2:21 am
Location: Essex, UK

Post 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
Post Reply