Problem with TEXT and BLOB types
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...
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.