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: 301
        
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