Trying to add text fields with defined lengths to a table, I get the following:
MySQL said: You have an error in your SQL syntax near '(25) BINARY NULL ,short_office TEXT(3) BINARY NULL ,phone TEXT(15) BINARY NULL ,' at line 1.
Query: CREATE TABLE offices(Office TEXT(25) BINARY NULL ,short_office TEXT(3) BINARY NULL ,phone TEXT(15) BINARY NULL ,fax TEXT(15) BINARY NULL ,server TEXT(30) BINARY NULL , INDEX (Office,short_office,server), UNIQUE (short_office,server))
MySQL said: You have an error in your SQL syntax near '(25) BINARY NULL ,short_office TEXT(3) BINARY NULL ,phone TEXT(15) BINARY NULL ,' at line 1.
Query: CREATE TABLE offices(Office TEXT(25) BINARY NULL ,short_office TEXT(3) BINARY NULL ,phone TEXT(15) BINARY NULL ,fax TEXT(15) BINARY NULL ,server TEXT(30) BINARY NULL , INDEX (Office,short_office,server), UNIQUE (short_office,server))