Inserting data into MySQL

Hello, i am currently getting the following error:

??? Error using ==> database.insert at 178 Row size too large (> 8126). Changing some columns to TEXT or BLOB or using ROW_FORMAT=DYNAMIC or ROW_FORMAT=COMPRESSED may help. In current row format, BLOB prefix of 768 bytes is stored inline.

i currently am using this bit of code to insert the data:

insert(conn, 'Sample', colnames, sample2);

Sample 2 contains 150 columns of data with each column data being a string of information of ~ 190-200 characters long.

initally my MySQL table datatype was varchar(250), i have changed this to text, longtext, blob, longblob....i have changed the row_format to dynamic or compressed for each datatype i have tried but still no luck.

can someone help, and know away around it please.

Thank you in advance