The maximum row size for the used table type, not counting BLOBs, is 65535. You have to change some columns to TEXT or BLOBs
Posted
by
Matthew Chambers
on Stack Overflow
See other posts from Stack Overflow
or by Matthew Chambers
Published on 2012-09-22T21:30:30Z
Indexed on
2012/09/22
21:37 UTC
Read the original article
Hit count: 251
mysql
Hello I am getting the below message on a table i am trying to create
The maximum row size for the used table type, not counting BLOBs, is 65535. You have to change some columns to TEXT or BLOBs
Anyone know the answer to this please
-- Table warrington_central
.job
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS warrington_central
.job
(
id
MEDIUMINT(8) UNSIGNED NOT NULL AUTO_INCREMENT ,
alias_title
VARCHAR(255) NOT NULL ,
reference_number
VARCHAR(100) NOT NULL ,
title
VARCHAR(255) NOT NULL ,
primary_category
SMALLINT(5) UNSIGNED NOT NULL ,
secondary_category
SMALLINT(5) UNSIGNED NOT NULL ,
tertiary_category
SMALLINT(5) UNSIGNED NULL ,
address_id
BIGINT(20) UNSIGNED NOT NULL ,
geolocation_id
BIGINT(20) UNSIGNED NULL ,
company
VARCHAR(255) NOT NULL ,
description
VARCHAR(10000) NOT NULL ,
skills_required
VARCHAR(10000) NOT NULL ,
job_type
TINYINT(2) UNSIGNED NOT NULL ,
experience_months_required
TINYINT(2) UNSIGNED NOT NULL ,
experience_years_required
TINYINT(2) UNSIGNED NOT NULL ,
salary_range
VARCHAR(30) NOT NULL ,
extra_benefits_above_salary
VARCHAR(500) NOT NULL ,
available_from
DATE NULL ,
available_to
DATE NULL ,
extra_location_details
VARCHAR(1000) NOT NULL ,
contact_email
VARCHAR(100) NOT NULL ,
contact_phone_number
VARCHAR(20) NOT NULL ,
contact_mobile_number
VARCHAR(20) NOT NULL ,
terms_conditions_application
VARCHAR(5000) NOT NULL ,
link_to_profile
ENUM('0','1') NOT NULL ,
created_on
DATETIME NOT NULL ,
updated_on
DATETIME NOT NULL ,
updated_by
BIGINT(20) UNSIGNED NOT NULL ,
add_contact_form
ENUM('0','1') NOT NULL ,
admin_package_id
TINYINT(1) UNSIGNED NOT NULL ,
package_start_date
DATETIME NOT NULL ,
package_end_date
DATETIME NULL ,
package_comment
VARCHAR(500) NOT NULL ,
viewable_to_members_only
ENUM('0','1') NOT NULL ,
advertise_to
DATETIME NULL ,
show_comment
ENUM('0','1') NOT NULL ,
hits
BIGINT(20) UNSIGNED NOT NULL DEFAULT 0 ,
visible
ENUM('0','1') NOT NULL DEFAULT '0' ,
approved
ENUM('I/* large SQL query (3.9 KB), snipped at 2,000 characters /
/ SQL Error (1118): Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535. You have to change some columns to TEXT or BLOBs */
SHOW WARNINGS;
© Stack Overflow or respective owner