title: Pandas to SQL (via SQL Alchemy) yields Unicode Encode Error
body: <p>I have these CSV files (top link to zip file from <a href="https://www.cms.gov/Research-Statistics-Data-and-Systems/Statistics-Trends-and-Reports/MCRAdvPartDEnrolData/Monthly-Enrollment-by-Contract-Plan-State-County-Items/Monthly-Enrollment-by-CPSC-2016-04.html?DLPage=1&amp;DLEntries=10&amp;DLSort=1&amp;DLSortDir=descending" rel="nofollow">here</a>) that I am trying to insert into an Oracle database.
  I get this error when using the following code below. I tried encoding with utf-8 but no dice...</p>
  
  <pre><code>UnicodeEncodeError: 'ascii' codec can't encode character '\xdf' in position 18: 
  ordinal not in range(128)
  </code></pre>
  
  <p>Code being used:</p>
  
  <pre><code>import pandas as pd
  from sqlalchemy import create_engine
  import cx_Oracle as cx
  pwd=input('Enter Password for server:')
  engine = create_engine('oracle+cx_oracle://schema:'+pwd+'@server:1521/service_name')
  df=pd.read_csv(r'path\data.csv',encoding='latin-1',index_col=0)
  name='table1'
  df.to_sql(name,engine,if_exists='append')
  </code></pre>
  
  <p>When I just open the csv file via pd.read_csv, it works just fine in my Jupyter notebook.</p>