[mysql] Error Code: 1118 Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs

상황

Error Code: 1118. Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs

 

해결

VARCHAR() 필드들을 TEXT() 로 변경

 

 

추가

VARCHAR 와 TEXT 차이

• TEXT 필드는 기본 값을 가질 수 없음

• TEXT 열의 처음 n 개의 문자만 인덱싱 가능.