Limitation in MySQL?

Question

MySQL

The table has 500 fields. Yes, 500. I need exactly 500 text fields. The field type is CHAR with a size of 30. When writing to these fields, the query goes up to 240 and then such errors come up
error #1118 while executing query "UPDATE `table` SET `area_241` = '0.000,0.000,0.000' WHERE `fID` = ' 1'": 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.
Tried such queries to the database -
ALTER TABLE `table` ENGINE = InnoDB, ROW_FORMAT = Dynamic
Still does not work. What to do?

Answer 1

yes
https://www.percona.com/blog/2011/04/07/innodb-row...
https://stackoverflow.com/questions/13283381/row-s...