title: Creating MySQL table getting SQLSTATE[42000] error 1118. Row size too large
body: <p>I have a Laravel Migration (creating a table) and it is giving me this error below.  THe problem is, I'm actually just duplicating a table that the State of Florida provides and provide the schema and what to set each field to.  I have no idea how I could change it.</p>
  
  <p>This is on mysql  Ver 14.14 Distrib 5.5.40, for debian-linux-gnu (x86_64) using readline 6.3</p>
  
  <pre><code>[Illuminate\Database\QueryException]
    SQLSTATE[42000]: Syntax error or access violation: 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
  </code></pre>
  
  <p><strong>The full migration is below:</strong></p>
  
  <pre><code>    Schema::create('rets_property_res_bonita', function(Blueprint $table)
      {
          $table-&gt;increments('id');
          $table-&gt;decimal('Acres',14,4)-&gt;nullable();
          $table-&gt;integer('ActiveOpenHouseCount')-&gt;nullable();
          $table-&gt;text('AdditionalRooms')-&gt;nullable();
          $table-&gt;text('Amenities')-&gt;nullable();
          $table-&gt;decimal('AmenityRecFee',17,2)-&gt;nullable();
          $table-&gt;string('AmenRecFreq')-&gt;nullable();
          $table-&gt;decimal('ApplicationFee',17,2)-&gt;nullable();
          $table-&gt;text('Approval')-&gt;nullable();
          $table-&gt;integer('ApproxLivingArea')-&gt;nullable();
          $table-&gt;string('AssociationMngmtPhone')-&gt;nullable();
          $table-&gt;integer('BathsFull')-&gt;nullable();
          $table-&gt;integer('BathsHalf')-&gt;nullable();
          $table-&gt;decimal('BathsTotal',7,2)-&gt;nullable();
          $table-&gt;text('BedroomDesc')-&gt;nullable();
          $table-&gt;string('Bedrooms')-&gt;nullable();
          $table-&gt;integer('BedsTotal')-&gt;nullable();
          $table-&gt;string('Block')-&gt;nullable();
          $table-&gt;text('BoatAccess')-&gt;nullable();
          $table-&gt;char('BuilderProductYN',1)-&gt;nullable();
          $table-&gt;text('BuildingDesc')-&gt;nullable();
          $table-&gt;string('BuildingDesign')-&gt;nullable();
          $table-&gt;string('BuildingNumber')-&gt;nullable();
          $table-&gt;string('BuyersCountryOfResidence')-&gt;nullable();
          $table-&gt;char('CableAvailableYN',1)-&gt;nullable();
          $table-&gt;string('CanalWidth')-&gt;nullable();
          $table-&gt;string('CarportDesc')-&gt;nullable();
          $table-&gt;integer('CarportSpaces')-&gt;nullable();
          $table-&gt;integer('CDOM')-&gt;nullable();
          $table-&gt;string('City')-&gt;nullable();
          $table-&gt;dateTime('CloseDate')-&gt;nullable();
          $table-&gt;decimal('ClosePrice',16,2)-&gt;nullable();
          $table-&gt;bigInteger('CoListAgent_MUI')-&gt;nullable();
          $table-&gt;string('CoListAgentDirectWorkPhone')-&gt;nullable();
          $table-&gt;string('CoListAgentEmail')-&gt;nullable();
          $table-&gt;string('CoListAgentFullName')-&gt;nullable();
          $table-&gt;string('CoListAgentMLSID')-&gt;nullable();
          $table-&gt;bigInteger('CoListOffice_MUI')-&gt;nullable();
          $table-&gt;string('CoListOfficeMLSID')-&gt;nullable();
          $table-&gt;string('CoListOfficeName')-&gt;nullable();
          $table-&gt;string('CoListOfficePhone')-&gt;nullable();
          $table-&gt;text('CommunityType')-&gt;nullable();
          $table-&gt;dateTime('ConditionalDate')-&gt;nullable();
          $table-&gt;decimal('CondoFee',17,2)-&gt;nullable();
          $table-&gt;string('CondoFeeFreq')-&gt;nullable();
          $table-&gt;text('Construction')-&gt;nullable();
          $table-&gt;char('ContactSellerForShowingYN',1)-&gt;nullable();
          $table-&gt;string('ContingencyType')-&gt;nullable();
          $table-&gt;dateTime('ContingentExpirationDate')-&gt;nullable();
          $table-&gt;text('Cooling')-&gt;nullable();
          $table-&gt;bigInteger('CoSellingAgent_MUI')-&gt;nullable();
          $table-&gt;string('CoSellingAgentDirectWorkPhone')-&gt;nullable();
          $table-&gt;string('CoSellingAgentEmail')-&gt;nullable();
          $table-&gt;string('CoSellingAgentFullName')-&gt;nullable();
          $table-&gt;string('CoSellingAgentMLSID')-&gt;nullable();
          $table-&gt;bigInteger('CoSellingOffice_MUI')-&gt;nullable();
          $table-&gt;string('CoSellingOfficeMLSID')-&gt;nullable();
          $table-&gt;string('CoSellingOfficeName')-&gt;nullable();
          $table-&gt;string('CoSellingOfficePhone')-&gt;nullable();
          $table-&gt;string('CountyOrParish')-&gt;nullable();
          $table-&gt;dateTime('CreatedDate')-&gt;nullable();
          $table-&gt;decimal('CurrentPrice',16,2)-&gt;nullable();
          $table-&gt;string('Development')-&gt;nullable();
          $table-&gt;string('DevelopmentName')-&gt;nullable();
          $table-&gt;text('DiningDescription')-&gt;nullable();
          $table-&gt;integer('DOM')-&gt;nullable();
          $table-&gt;string('ElementarySchool')-&gt;nullable();
          $table-&gt;string('Elevator')-&gt;nullable();
          $table-&gt;text('Equipment')-&gt;nullable();
          $table-&gt;text('ExteriorFeatures')-&gt;nullable();
          $table-&gt;text('ExteriorFinish')-&gt;nullable();
          $table-&gt;char('FIRPTAYN',1)-&gt;nullable();
          $table-&gt;text('Flooring')-&gt;nullable();
          $table-&gt;text('FloorPlanType')-&gt;nullable();
          $table-&gt;char('ForeclosedREOYN',1)-&gt;nullable();
          $table-&gt;string('FullAddress')-&gt;nullable();
          $table-&gt;text('FurnishedDesc')-&gt;nullable();
          $table-&gt;string('GarageDesc')-&gt;nullable();
          $table-&gt;string('GarageDimension')-&gt;nullable();
          $table-&gt;decimal('GarageSpaces',11,2)-&gt;nullable();
          $table-&gt;text('GuestHouseDesc')-&gt;nullable();
          $table-&gt;string('GuestHouseLivingArea')-&gt;nullable();
          $table-&gt;text('GulfAccessType')-&gt;nullable();
          $table-&gt;char('GulfAccessYN',1)-&gt;nullable();
          $table-&gt;text('Heat')-&gt;nullable();
          $table-&gt;string('HighSchool')-&gt;nullable();
          $table-&gt;string('HOADesc')-&gt;nullable();
          $table-&gt;decimal('HOAFee',17,2)-&gt;nullable();
          $table-&gt;string('HOAFeeFreq')-&gt;nullable();
          $table-&gt;char('IDXOptInYN',1)-&gt;nullable();
          $table-&gt;dateTime('InactiveDate')-&gt;nullable();
          $table-&gt;text('InteriorFeatures')-&gt;nullable();
          $table-&gt;text('Irrigation')-&gt;nullable();
          $table-&gt;text('KitchenDescription')-&gt;nullable();
          $table-&gt;decimal('LandLeaseFee',17,2)-&gt;nullable();
          $table-&gt;string('LandLeaseFeeFreq')-&gt;nullable();
          $table-&gt;dateTime('LastChangeTimestamp')-&gt;nullable();
          $table-&gt;string('LastChangeType')-&gt;nullable();
          $table-&gt;decimal('LastListPrice',16,2)-&gt;nullable();
          $table-&gt;string('LastStatus')-&gt;nullable();
          $table-&gt;char('LeaseLimitsYN',1)-&gt;nullable();
          $table-&gt;integer('LeasesPerYear')-&gt;nullable();
          $table-&gt;string('LegalDesc')-&gt;nullable();
          $table-&gt;string('LegalUnit')-&gt;nullable();
          $table-&gt;bigInteger('ListAgent_MUI')-&gt;nullable();
          $table-&gt;string('ListAgentDirectWorkPhone')-&gt;nullable();
          $table-&gt;string('ListAgentEmail')-&gt;nullable();
          $table-&gt;string('ListAgentFullName')-&gt;nullable();
          $table-&gt;string('ListAgentMLSID')-&gt;nullable();
          $table-&gt;char('ListingOnInternetYN',1)-&gt;nullable();
          $table-&gt;string('ListOfficeMLSID')-&gt;nullable();
          $table-&gt;string('ListOfficeName')-&gt;nullable();
          $table-&gt;string('ListOfficePhone')-&gt;nullable();
          $table-&gt;decimal('ListPrice',16,2)-&gt;nullable();
          $table-&gt;integer('LotBack')-&gt;nullable();
          $table-&gt;text('LotDesc')-&gt;nullable();
          $table-&gt;integer('LotFrontage')-&gt;nullable();
          $table-&gt;integer('LotLeft')-&gt;nullable();
          $table-&gt;integer('LotRight')-&gt;nullable();
          $table-&gt;string('LotUnit')-&gt;nullable();
          $table-&gt;text('Maintenance')-&gt;nullable();
          $table-&gt;string('Management')-&gt;nullable();
          $table-&gt;decimal('MandatoryClubFee',17,2)-&gt;nullable();
          $table-&gt;string('MandatoryClubFeeFreq')-&gt;nullable();
          $table-&gt;char('MandatoryHOAYN',1)-&gt;nullable();
          $table-&gt;text('MasterBathDescription')-&gt;nullable();
          $table-&gt;decimal('MasterHOAFee',17,2)-&gt;nullable();
          $table-&gt;string('MasterHOAFeeFreq')-&gt;nullable();
          $table-&gt;bigInteger('matrix_unique_id')-&gt;nullable();
          $table-&gt;dateTime('MatrixModifiedDT')-&gt;nullable();
          $table-&gt;string('MiddleSchool')-&gt;nullable();
          $table-&gt;integer('MinDaysofLease')-&gt;nullable();
          $table-&gt;string('MLS')-&gt;nullable();
          $table-&gt;string('MLSAreaMajor')-&gt;nullable();
          $table-&gt;string('MLSNumber')-&gt;nullable();
          $table-&gt;integer('NumberofCeilingFans')-&gt;nullable();
          $table-&gt;integer('NumUnitFloor')-&gt;nullable();
          $table-&gt;dateTime('OffMarketDate')-&gt;nullable();
          $table-&gt;integer('OneTimeLandLeaseFee')-&gt;nullable();
          $table-&gt;integer('OneTimeMandatoryClubFee')-&gt;nullable();
          $table-&gt;integer('OneTimeOtheFee')-&gt;nullable();
          $table-&gt;integer('OneTimeRecLeaseFee')-&gt;nullable();
          $table-&gt;integer('OneTimeSpecialAssessmentFee')-&gt;nullable();
          $table-&gt;integer('OpenHouseCount')-&gt;nullable();
          $table-&gt;string('OpenHouseUpcoming')-&gt;nullable();
          $table-&gt;decimal('OriginalListPrice',16,2)-&gt;nullable();
          $table-&gt;string('OwnershipDesc')-&gt;nullable();
          $table-&gt;string('ParcelNumber')-&gt;nullable();
          $table-&gt;text('Parking')-&gt;nullable();
          $table-&gt;dateTime('PendingSaleDate')-&gt;nullable();
          $table-&gt;string('Pets')-&gt;nullable();
          $table-&gt;integer('PetsLimitMaxNumber')-&gt;nullable();
          $table-&gt;integer('PetsLimitMaxWeight')-&gt;nullable();
          $table-&gt;string('PetsLimitOther')-&gt;nullable();
          $table-&gt;integer('PhotoCount')-&gt;nullable();
          $table-&gt;dateTime('PhotoModificationTimestamp')-&gt;nullable();
          $table-&gt;text('Possession')-&gt;nullable();
          $table-&gt;string('PostalCode')-&gt;nullable();
          $table-&gt;string('PostalCodePlus4')-&gt;nullable();
          $table-&gt;char('PostContractServYN',1)-&gt;nullable();
          $table-&gt;char('PotentialShortSaleYN',1)-&gt;nullable();
          $table-&gt;char('PresentNegoContYN',1)-&gt;nullable();
          $table-&gt;decimal('PricePerAcre',14,2)-&gt;nullable();
          $table-&gt;decimal('PricePerSqFt',14,2)-&gt;nullable();
          $table-&gt;text('PrivatePoolDesc')-&gt;nullable();
          $table-&gt;char('PrivatePoolYN',1)-&gt;nullable();
          $table-&gt;text('PrivateSpaDesc')-&gt;nullable();
          $table-&gt;char('PrivateSpaYN',1)-&gt;nullable();
          $table-&gt;char('PropertyAddressonInternetYN',1)-&gt;nullable();
          $table-&gt;text('PropertyInformation')-&gt;nullable();
          $table-&gt;string('PropertyType')-&gt;nullable();
          $table-&gt;integer('Range')-&gt;nullable();
          $table-&gt;string('RearExposure')-&gt;nullable();
          $table-&gt;text('Restrictions')-&gt;nullable();
          $table-&gt;text('Road')-&gt;nullable();
          $table-&gt;text('Roof')-&gt;nullable();
          $table-&gt;integer('RoomCount')-&gt;nullable();
          $table-&gt;integer('Section')-&gt;nullable();
          $table-&gt;bigInteger('SellingAgent_MUI')-&gt;nullable();
          $table-&gt;string('SellingAgentDirectWorkPhone')-&gt;nullable();
          $table-&gt;string('SellingAgentEmail')-&gt;nullable();
          $table-&gt;string('SellingAgentFullName')-&gt;nullable();
          $table-&gt;string('SellingAgentMLSID')-&gt;nullable();
          $table-&gt;bigInteger('SellingOffice_MUI')-&gt;nullable();
          $table-&gt;string('SellingOfficeMLSID')-&gt;nullable();
          $table-&gt;string('SellingOfficeName')-&gt;nullable();
          $table-&gt;string('SellingOfficePhone')-&gt;nullable();
          $table-&gt;decimal('SellPricePerSqFt',17,2)-&gt;nullable();
          $table-&gt;text('Sewer')-&gt;nullable();
          $table-&gt;text('SourceofMeasureLivingArea')-&gt;nullable();
          $table-&gt;text('SourceofMeasureLotDimensions')-&gt;nullable();
          $table-&gt;text('SourceofMeasureLotSize')-&gt;nullable();
          $table-&gt;text('SourceofMeasureTotalArea')-&gt;nullable();
          $table-&gt;decimal('SpecialAssessment',17,2)-&gt;nullable();
          $table-&gt;string('SpecialAssessmentFeeFreq')-&gt;nullable();
          $table-&gt;text('SpecialInformation')-&gt;nullable();
          $table-&gt;string('StateOrProvince')-&gt;nullable();
          $table-&gt;string('Status')-&gt;nullable();
          $table-&gt;dateTime('StatusContractualSearchDate')-&gt;nullable();
          $table-&gt;string('StatusType')-&gt;nullable();
          $table-&gt;text('StormProtection')-&gt;nullable();
          $table-&gt;string('StreetDirPrefix')-&gt;nullable();
          $table-&gt;string('StreetDirSuffix')-&gt;nullable();
          $table-&gt;string('StreetName')-&gt;nullable();
          $table-&gt;string('StreetNumber')-&gt;nullable();
          $table-&gt;string('StreetNumberModifier')-&gt;nullable();
          $table-&gt;string('StreetSuffix')-&gt;nullable();
          $table-&gt;string('SubCondoName')-&gt;nullable();
          $table-&gt;string('SubdivisionNumber')-&gt;nullable();
          $table-&gt;string('Table')-&gt;nullable();
          $table-&gt;text('TaxDesc')-&gt;nullable();
          $table-&gt;string('TaxDistrictType')-&gt;nullable();
          $table-&gt;decimal('Taxes',17,2)-&gt;nullable();
          $table-&gt;integer('TaxYear')-&gt;nullable();
          $table-&gt;dateTime('TempOffMarketDate')-&gt;nullable();
          $table-&gt;dateTime('TerminatedDate')-&gt;nullable();
          $table-&gt;text('Terms')-&gt;nullable();
          $table-&gt;integer('TotalArea')-&gt;nullable();
          $table-&gt;integer('TotalFloors')-&gt;nullable();
          $table-&gt;integer('Township')-&gt;nullable();
          $table-&gt;decimal('TransferFee',17,2)-&gt;nullable();
          $table-&gt;integer('UnitCount')-&gt;nullable();
          $table-&gt;string('UnitFloor')-&gt;nullable();
          $table-&gt;string('UnitNumber')-&gt;nullable();
          $table-&gt;integer('UnitsinBuilding')-&gt;nullable();
          $table-&gt;integer('UnitsinComplex')-&gt;nullable();
          $table-&gt;text('View')-&gt;nullable();
          $table-&gt;string('VirtualTourURL')-&gt;nullable();
          $table-&gt;text('Water')-&gt;nullable();
          $table-&gt;text('WaterfrontDesc')-&gt;nullable();
          $table-&gt;char('WaterfrontYN',1)-&gt;nullable();
          $table-&gt;text('Windows')-&gt;nullable();
          $table-&gt;dateTime('WithdrawnDate')-&gt;nullable();
          $table-&gt;integer('YearBuilt')-&gt;nullable();
          $table-&gt;string('ZoningCode')-&gt;nullable();
          $table-&gt;timestamps();
      });
  </code></pre>