blaze / blaze/odo

sql_csv.py does not respect encoding kwarg

Open
#411 0 comments 0 reactions 0 assignees View on GitHub
Dominant language
Python
Stars
1k
Forks
131
PR merge metrics
No merged PRs in 30d

Description

import odd

csv=odo.resource('/tmp/bigmessy.csv', delimiter=';', decimal=',', encoding='cp1251')

sql=odo.resource('mysql+mysqlconnector://user:password@localhost:3306/db::bigcsv', encoding='cp1251', dshape='...')

odo.odo(csv, sql)

DatabaseError: (mysql.connector.errors.DatabaseError) 1300 (HY000): Invalid utf8 character string: '"' [SQL: 'LOAD DATA INFILE %(path)s\n INTO TABLE bigcsv\n CHARACTER SET %(encoding)s\n FIELDS\n TERMINATED BY %(delimiter)s\n ENCLOSED BY %(quotechar)s\n ESCAPED BY %(escapechar)s\n LINES TERMINATED BY %(lineterminator)s\n IGNORE %(skiprows)s LINES\n '] [parameters: {'encoding': 'utf8', 'skiprows': 1, 'delimiter': ';', 'lineterminator': '\r\n', 'escapechar': '\', 'path': '/tmp/bigmessy.csv', 'quotechar': '"'}]

Contributor guide

No contributing guide indexed for this repository

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.