Azu Posted May 27, 2007 Share Posted May 27, 2007 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 =/ Quote Link to comment Share on other sites More sharing options...
bubblegum.anarchy Posted May 27, 2007 Share Posted May 27, 2007 varchar(255) Quote Link to comment Share on other sites More sharing options...
Azu Posted May 27, 2007 Author Share Posted May 27, 2007 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. Quote Link to comment Share on other sites More sharing options...
AndyB Posted May 27, 2007 Share Posted May 27, 2007 And I thought a type = text field could store 65535 bytes Quote Link to comment Share on other sites More sharing options...
Azu Posted May 28, 2007 Author Share Posted May 28, 2007 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 Quote Link to comment Share on other sites More sharing options...
AndyB Posted May 28, 2007 Share Posted May 28, 2007 This is actually about a MySQL database, isn't it? Quote Link to comment Share on other sites More sharing options...
bubblegum.anarchy Posted May 28, 2007 Share Posted May 28, 2007 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 Quote Link to comment Share on other sites More sharing options...
fenway Posted May 30, 2007 Share Posted May 30, 2007 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! Quote Link to comment Share on other sites More sharing options...
bubblegum.anarchy Posted May 31, 2007 Share Posted May 31, 2007 I doubt that the client used matters but just incase - ALTER queries performed via SQLyog community v5.31 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.