Reraise(type(exception), exception, tb=exc_tb, cause=cause)įile "C:\ProgramData\Anaconda3\lib\site-packages\sqlalchemy\util\compat.py", line 186, in reraiseįile "C:\ProgramData\Anaconda3\lib\site-packages\sqlalchemy\engine\base.py", line 1170, in _execute_contextįile "C:\ProgramData\Anaconda3\lib\site-packages\sqlalchemy\engine\default.py", line 504, in do_executemanyĬursor.executemany(statement, parameters) Return connection._execute_clauseelement(self, multiparams, params)įile "C:\ProgramData\Anaconda3\lib\site-packages\sqlalchemy\engine\base.py", line 1060, in _execute_clauseelementįile "C:\ProgramData\Anaconda3\lib\site-packages\sqlalchemy\engine\base.py", line 1200, in _execute_contextįile "C:\ProgramData\Anaconda3\lib\site-packages\sqlalchemy\engine\base.py", line 1413, in _handle_dbapi_exceptionįile "C:\ProgramData\Anaconda3\lib\site-packages\sqlalchemy\util\compat.py", line 203, in raise_from_cause Self._execute_insert(conn, keys, chunk_iter)įile "C:\ProgramData\Anaconda3\lib\site-packages\pandas\io\sql.py", line 645, in _execute_insertĬonn.execute(self.insert_statement(), data)įile "C:\ProgramData\Anaconda3\lib\site-packages\sqlalchemy\engine\base.py", line 948, in executeįile "C:\ProgramData\Anaconda3\lib\site-packages\sqlalchemy\sql\elements.py", line 269, in _execute_on_connection
UNICODE Using encoding ASCII 'US-ASCII' and UNICODE 'UCS-2-INTERNAL'įor now, I can workaround by ensuring that I always use None instead of '', but would appreciate it if someone knows of other workarounds.įile "C:\ProgramData\Anaconda3\lib\site-packages\pandas\core\generic.py", line 1534, in to_sqlįile "C:\ProgramData\Anaconda3\lib\site-packages\pandas\io\sql.py", line 473, in to_sqlįile "C:\ProgramData\Anaconda3\lib\site-packages\pandas\io\sql.py", line 1156, in to_sqlįile "C:\ProgramData\Anaconda3\lib\site-packages\pandas\io\sql.py", line 670, in insert