title: Data insertion in SQL server with pandas
body: <p>I'm trying to upload a dataframe in SQL server using pandas (to_sql) function, I get the below error</p>
  
  <blockquote>
    <p>[SQL Server Native Client 11.0]Invalid character value for cast
    specification (0) (SQLExecDirectW)')</p>
  </blockquote>
  
  <p>I checked for variables' names and types and they are exactly the same in the SQL database and pandas dataframe.</p>
  
  <p>How can I fix this?
  Thanks </p>
  
  <pre><code>df.to_sql(raw_table, connDB, if_exists='append', index=False  )
  </code></pre>