I'm running this question to setup a
VARBINARY (If only for this to become so, for any real reason) area for my database:
CREATE TABLE `test_books` (`id` int UNSIGNED NOT NULL,`book` VARBINARY, `timestamp` int(11) NOT NULL, UNIQUE KEY `id` (`id`))
It hands us a standard syntax error saying to check on all of the remaining code after 'VARBINARY'.
My MySQL server version is
5.0.87.d10, that is stated to aid the datatype since 5..
VARBINARY straight into
int and also the query labored fine, could there be something I omitted after it?
You have to specify an overall length for [var]binary fields, just like you need to do for char/varchar.
You have to add size varbinary:
VARBINARY( 100 )