title: Sqlalchemy String or binary data would be truncated
body: <p>I am trying to insert a table from a pandas dataframe to a SQL database and I get the following error message:</p>
  <pre><code>pyodbc.DataError: ('22001', '[22001] [Microsoft][ODBC SQL Server Driver][SQL Server]String or binary data would be truncated. (8152) (SQLExecDirectW); [22001] [Microsoft][ODBC SQL Server Driver][SQL Server]The statement has been terminated. (3621)')
  </code></pre>
  <p>Every time I try to push it. I have changed the data types in the SQL table, I have removed potential missing values in the dataframe, all data types in each column of the table coincide with the ones of the dataframe.</p>
  <p>Could someone explain me in depth what's going on and how to solve this problem?</p>