mysql - Effects of changing datatype of a column from varchar to text -

the text data have column in database in enterprise application (uses hibernate) huge , after increasing varchar size specific number, don't have other choice change datatype text. can me understand how may affect application. need take care of else or changing datatype works ?

you should use text. although, that's same thing varchar:

if declared type of column contains of strings "char", "clob", or "text" column has text affinity. notice type varchar contains string "char" , assigned text affinity

also note

note numeric arguments in parentheses following type name (ex: "varchar(255)") ignored sqlite - sqlite not impose length restrictions (other large global sqlite_max_length limit) on length of strings, blobs or numeric values.

your application work fine datatype text.you don't need take care of thing