mysql does a row too large error and i can’t fix it

  database, mysql, php, sql-server

my .sql does this : Row Size Too Large

code :
CREATE TABLE vrp_user_vehicles (
ids int(11) NOT NULL,
user_id int(11) NOT NULL DEFAULT ‘0’,
vehicle varchar(255) NOT NULL DEFAULT ”,
veh_type varchar(255) NOT NULL DEFAULT ‘default’,
vehicle_plate varchar(255) NOT NULL,
vehicle_colorprimary varchar(255) DEFAULT NULL,
vehicle_colorsecondary varchar(255) DEFAULT NULL,
vehicle_pearlescentcolor varchar(255) DEFAULT NULL,
vehicle_wheelcolor varchar(255) DEFAULT NULL,
vehicle_plateindex varchar(255) DEFAULT NULL,
vehicle_neoncolor1 varchar(255) DEFAULT NULL,
vehicle_neoncolor2 varchar(255) DEFAULT NULL,
vehicle_neoncolor3 varchar(255) DEFAULT NULL,
vehicle_windowtint varchar(255) DEFAULT NULL,
vehicle_wheeltype varchar(255) DEFAULT NULL,
vehicle_mods0 varchar(255) DEFAULT NULL,
vehicle_mods1 varchar(255) DEFAULT NULL,
vehicle_mods2 varchar(255) DEFAULT NULL,
vehicle_mods3 varchar(255) DEFAULT NULL,
vehicle_mods4 varchar(255) DEFAULT NULL,
vehicle_mods5 varchar(255) DEFAULT NULL,
vehicle_mods6 varchar(255) DEFAULT NULL,
vehicle_mods7 varchar(255) DEFAULT NULL,
vehicle_mods8 varchar(255) DEFAULT NULL,
vehicle_mods9 varchar(255) DEFAULT NULL,
vehicle_mods10 varchar(255) DEFAULT NULL,
vehicle_mods11 varchar(255) DEFAULT NULL,
vehicle_mods12 varchar(255) DEFAULT NULL,
vehicle_mods13 varchar(255) DEFAULT NULL,
vehicle_mods14 varchar(255) DEFAULT NULL,
vehicle_mods15 varchar(255) DEFAULT NULL,
vehicle_mods16 varchar(255) DEFAULT NULL,
vehicle_turbo varchar(255) NOT NULL DEFAULT ‘off’,
vehicle_tiresmoke varchar(255) NOT NULL DEFAULT ‘off’,
vehicle_xenon varchar(255) NOT NULL DEFAULT ‘off’,
vehicle_mods23 varchar(255) DEFAULT NULL,
vehicle_mods24 varchar(255) DEFAULT NULL,
vehicle_neon0 varchar(255) DEFAULT NULL,
vehicle_neon1 varchar(255) DEFAULT NULL,
vehicle_neon2 varchar(255) DEFAULT NULL,
vehicle_neon3 varchar(255) DEFAULT NULL,
vehicle_bulletproof varchar(255) DEFAULT NULL,
vehicle_smokecolor1 varchar(255) DEFAULT NULL,
vehicle_smokecolor2 varchar(255) DEFAULT NULL,
vehicle_smokecolor3 varchar(255) DEFAULT NULL,
vehicle_modvariation varchar(255) NOT NULL DEFAULT ‘off’
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

can anyone help me change this to blob?

Source: Ask PHP

LEAVE A COMMENT