title: Indexing a MySql TEXT column?
body: <p>I ran this using MySql and it appears to not like <code>TEXT</code>. With SQL server I use <code>nvarchar(max)</code> What should I use in MySql? In other tables some fields will be descriptions and may be long so at the moment I am thinking that fixed length is bad.</p>
  
  <pre><code>create table if not exists 
      misc_info (
          id INTEGER PRIMARY KEY AUTO_INCREMENT NOT NULL,
          key TEXT UNIQUE NOT NULL,
          value TEXT NOT NULL
      )ENGINE=INNODB;
  </code></pre>