sql_csv.py does not respect encoding kwarg
- 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.