1074, "column length too big for Column ' err_solution ' (max = 21845); Use BLOB or TEXT instead "

One point of note is that when SQLAlchemy uses Create_all () to build a table, import the model of those tables on the page where the Create_all () is located.

　　

Sqlalchemy.exc.OperationalError: (_mysql_exceptions. Operationalerror) (1074, "column length too big for Column ' err_solution ' (max = 21845); Use BLOB or TEXT instead ") [sql:u ' \ncreate TABLE amazon_errcode (\n\tcreate_date datetime, \n\tmodified_date datetime, \ n \tid integer not NULL auto_increment, \n\terr_code Integer, \n\terr_desc varchar (1024x768), \n\terr_solution varchar (65532), \n\tprimary KEY (id) \ n \ n "]

　

------------------2016-5-17 17:30:23--

Char text blob in Source:mysql

1074, "column length too big for Column ' err_solution ' (max = 21845); Use BLOB or TEXT instead "