Hi,

I have tried searching the forum for an answer, but have been unable to find one. I received this error while trying to create a test table.
--------

MySQL said: You have an error in your SQL syntax near '(15) BINARY NOT NULL DEFAULT 'FirstName' ,ID INT(10) BINARY NOT NULL AUTO_INCREM' at line 1.

Query: CREATE TABLE test(First TEXT(15) BINARY NOT NULL DEFAULT 'FirstName' ,ID INT(10) BINARY NOT NULL AUTO_INCREMENT)

--------

Any help would be appreciated. Thank you.


Robert Blackstone
Webmaster of Scato Search
http://www.scato.com