[GitHub] 15310944349 opened a new issue #3550: (sqlite3.ProgrammingError) You must not use 8-bit bytestrings unless you use a text_factory that can interpret 8-bit bytestrings (like text_factory = str). It is highly recommended that you instead just switch your application to Unicode strings

[gi...@git.apache.org]

15310944349 opened a new issue #3550: (sqlite3.ProgrammingError) You must not use 8-bit bytestrings unless you use a text_factory that can interpret 8-bit bytestrings (like text_factory = str). It is highly recommended that you instead just switch your application to Unicode strings
URL: https://github.com/apache/incubator-superset/issues/3550
 
 
   Make sure these boxes are checked before submitting your issue - thank you!
   
   - [ ] I have checked the superset logs for python stacktraces and included it here as text if any
   - [ ] I have reproduced the issue with at least the latest released version of superset
   - [ ] I have checked the issue tracker for the same issue and I haven't found one similar
   
   
   ### Superset version
   Superset 0.19.1
   
   ### Expected results
   get results data from remote mysql server
   
   ### Actual results
   ProgrammingError: (sqlite3.ProgrammingError) You must not use 8-bit bytestrings unless you use a text_factory that can interpret 8-bit bytestrings (like text_factory = str). It is highly recommended that you instead just switch your application to Unicode strings. [SQL: u'UPDATE "query" SET tmp_table_name=?, status=?, error_message=?, changed_on=? WHERE "query".id = ?'] [parameters: (None, u'failed', "unsupported format character '\xe5' (0xffffffe5) at index 74", '2017-09-29 08:06:59.720489', 559)]
   
   ### Steps to reproduce
   run the fllowing sql from sql editor:
   SELECT t_tm_article_id,title,subscribe_id FROM t_article WHERE title like '%????%'  limit 1'
   
   
 
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on GitHub and use the
URL above to go to the specific comment.
 
For queries about this service, please contact Infrastructure at:
users@infra.apache.org


With regards,
Apache Git Services