title: error in creating table in phpmyadmin
body: <p>I want to run the following sql command in phpmyadmin:</p>
  <pre><code>create table files(messageId INT NOT NULL, 
  messageBlockId INT PRIMARY KEY AUTO_INCREMENT, 
  data NVARCHAR(MAX), 
  Signatures NVARCHAR(MAX), 
  owner INT NOT NULL);  
  </code></pre>
  <p>I am gitting this error:</p>
  <blockquote>
  <h1>1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'MAX), Signatures NVARCHAR(MAX), owner INT NOT NULL)' at line 1</h1>
  </blockquote>
  <p>What should I do? I would have used the GUI in phpmyadmin to create table but it does not show NVARCHAR as datatype.</p>
  <p>Edit: I tried to change NVARCHAR(MAX) to VARCHAR(MAX) but the error still exists. Its Okay if I use varchar but how do I remove the error?</p>
  <p>Thanks :)</p>