MySQL Forums
Forum List  »  Newbie

Problem with TEXT and BLOB types
Posted by: Thejo Kote
Date: June 21, 2005 09:57PM

Hi,

I'm not able to create tables with TEXT or BLOB types. My query is -

create table cust_details
(
cust_num int(5) unsigned not null primary key auto_increment,
cust_name varchar(150),
cust_about text(500),
cust_type int(2)
);

And the error message is -

#1064 - You have an error in your SQL syntax near '(500),
cust_type int(2)
)' at line 5

I use v3.23.58. I've tried the same query in a MySQL installation of
v4.1.9 and it works. As I understand it from the documentation TEXT and
BLOB are supported in v3.23.58. Or, is that not the case. I'm using the
default version of MySQL that comes with Fedora Core 3.

What could be the issue? Thanks in advance...

Options: ReplyQuote


Subject
Written By
Posted
Problem with TEXT and BLOB types
June 21, 2005 09:57PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.