varchar(MAX) in MyISAM?

[Azu]

Would somebody please tell me how I can create a varchar(MAX) row in MyISAM? I tried to make one in SQLYog but it errored =/

[bubblegum.anarchy]

varchar(255)

[Azu]

varchar(MAX) can store up to 2gb of data though, and I need to store more then 8000bytes, and blob/text won't work for this.

[AndyB]

And I thought a type = text field could store 65535 bytes 

[Azu]

Yes it can I need to use varchar though so can somebody please tell me how to make a varchar(MAX) row in MyISAM? Like http://www.google.com/search?q=varchar%28MAX%29&start=0&ie=utf-8&oe=utf-8&client=firefox&rls=org.mozilla:en-US:unofficial

[AndyB]

This is actually about a MySQL database, isn't it?

[bubblegum.anarchy]

hmmm...

 

The following:

  ALTER TABLE ADD column_name varchar(255);

 

Adds:

  column_name varchar(255)

 

The following:

  ALTER TABLE ADD column_name varchar(256);

 

Adds:

  column_name text

[fenway]

hmmm...

 

The following:

  ALTER TABLE ADD column_name varchar(255);

 

Adds:

  column_name varchar(255)

 

The following:

  ALTER TABLE ADD column_name varchar(256);

 

Adds:

  column_name text

 

No kidding... I knew about silent changes, but not this one!

[bubblegum.anarchy]

I doubt that the client used matters but just incase - ALTER queries performed via SQLyog community v5.31