Hey Guys, this is more of a straight up MySQL question, but here goes: I'm updating an old Msql db dump, trying to get it to build under MYSQL 3.22.x. I think I've updated it ok, but when I try to build this database I get the following error:
Specified key was too long. Max key length is 256. Anyone run into this, or see a problem with my code that might be causing this??? Any help would be VERY greatly apreciated! (I'd DCC you a cookie if I could....)
CREATE TABLE manetwork (
listing INT NOT NULL,
name TEXT,
email TEXT,
city CHAR(50),
region CHAR(25) NOT NULL,
state CHAR(4) NOT NULL,
country CHAR(40),
age INT,
kstyle CHAR(75) NOT NULL,
style CHAR(150) NOT NULL,
INDEX manetwork_search (
listing,
region,
state,
kstyle,
style
),
UNIQUE INDEX manetwork_listing (
listing
)
) \g
