type of TEXT data problem

hello,

I've just a little problem (i'm a newbie)
I try to create a table with a colum of type TEXT
and it does'nt work
that is my code
CREATE TABLE test (
montest TEXT)
and it says to me URLarse error
and it works if i do :
CREATE TABLE test (
montest BLOB)

what's wrong and what must I do

thanks

Vince

------------------
VinceFrance

vroques,

<<< Text column type will work in mysql.>>>>


As per your storage requirment you can select your columntype.

if you want to store string(characters)in a column(with 1-255 characters).
You can use eigther char or varchar type.

eg;

CREATE TABLE test (
montest varchar(30));


if you are using BLOB ,then you can use the column with a maximum length of 65535 (2^16 - 1) characters.

See Mysql manual for getting details about column types.

------------------
SR -
shiju.dreamcenter.net

[This message has been edited by Shiju Rajan (edited May 01, 2000).]

I'm sorry but I have to disagree. I'm using the text type in several MySQL dabases right now. I did define it in lower case though I don't believe that makes a difference.

Robman

Robman,

sorry, text column type will work in mysql.
I given that statement with oracle experience.

thank you....


------------------
SR -
shiju.dreamcenter.net