MySQL: Cannot create table with VARBINARY?

encossisa

New Member
I am running this query to set up a \[code\]VARBINARY\[/code\] (I wish for it to be so, for a real reason) field for my database: \[code\]CREATE TABLE `test_books` (`id` int UNSIGNED NOT NULL,`book` VARBINARY, `timestamp` int(11) NOT NULL, UNIQUE KEY `id` (`id`))\[/code\]It hands me a standard syntax error telling me to check all the remaining code after 'VARBINARY'.My MySQL server version is \[code\]5.0.87.d10\[/code\], which is claimed to support the datatype since 5.0.I changed \[code\]VARBINARY\[/code\] directly into \[code\]int\[/code\] and the query worked fine, could there be something I left out after it?
 
Back
Top