I am running this query to set up a VARBINARY
(I wish for it to be so, for a real reason) field 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 me a standard syntax error telling me to check all the remaining code after 'VARBINARY'.
My MySQL server version is 5.0.87.d10
, which is claimed to support the datatype since 5.0.
I changed VARBINARY
directly into int
and the query worked fine, could there be something I left out after it?
You need to specify a length for [var]binary fields, just as you do for char/varchar.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With