mysql创建不限制大小的表_mysql创建表查询中的行大小太大错误

我正在尝试使用以下查询创建表

Create Table PerformaceReport

(

campaignID int,

keywordID bigint,

keyword varchar(8000),

avgPosition decimal(18,6),

cost int,

clicks int,

conv1PerClick int,

impressions int,

day datetime,

currency varchar(8000),

account varchar(8000),

timeZone varchar(8000),

adGroup varchar(8000),

adGroupState varchar(8000),

approvalStatus varchar(8000),

lowestPosition varchar(8000),

campaign varchar(8000),

campaignState varchar(8000),

convManyPerClick int,

totalConvValue decimal(18,6),

maxCPCSource varchar(8000),

clientName varchar(8000),

destinationURL varchar(8000),

device varchar(8000),

firstPageCPC int,

isNegative bit,

matchType varchar(8000),

maxCPC varchar(8000),

maxCPM varchar(8000),

highestPosition varchar(8000),

qualityScore int,

keywordState varchar(8000),

viewThroughConv int)

我收到以下错误

#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

任何人都可以让我知道如何避免此错误并使查询工作以创建表。