Mysql Row size too large. What is the risk of changing all varchar (255) to TEXT?

prompt when using mysql to create a database: 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.

means that the field is too large. Use the text or blobs type.

because the Chinese field type is: varchar (1000)

so when creating an English field: varchar (2000)

this is the varchar (2000) that reported the error.

solution: change varchar (2000) to text or blobs

--
then I changed all the varchar (255) to TEXT

what are the risks?

Php
Jun.05,2022

Don't change all varchar (255) to text with appropriate fields, just change varchar (2000) to text

MySQL Query : SELECT * FROM `codeshelper`.`v9_news` WHERE status=99 AND catid='6' ORDER BY rand() LIMIT 5
MySQL Error : Disk full (/tmp/#sql-temptable-64f5-1ea8379-1eb8.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
MySQL Errno : 1021
Message : Disk full (/tmp/#sql-temptable-64f5-1ea8379-1eb8.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
Need Help?