error in creating table in phpmyadmin

Question

I want to run the following sql command in phpmyadmin:

create table files(messageId INT NOT NULL, 
messageBlockId INT PRIMARY KEY AUTO_INCREMENT, 
data NVARCHAR(MAX), 
Signatures NVARCHAR(MAX), 
owner INT NOT NULL);  

I am gitting this error:

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

What should I do? I would have used the GUI in phpmyadmin to create table but it does not show NVARCHAR as datatype.

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?

Thanks :)

Answer 1

You should use VARCHAR(MAX), not NVARCHAR(MAX)