| Bug #88174 | Table import Wizard: ERROR: Import data file: 'ascii' codec can't decode byte | ||
|---|---|---|---|
| Submitted: | 21 Oct 2017 15:01 | Modified: | 21 Apr 2018 22:11 |
| Reporter: | Sergio Lencinas | Email Updates: | |
| Status: | No Feedback | Impact on me: | |
| Category: | MySQL Workbench | Severity: | S2 (Serious) |
| Version: | 6.3 | OS: | MacOS (10.11.6) |
| Assigned to: | CPU Architecture: | Any | |
[22 Oct 2017 8:20]
Peter Laursen
Looks like a Python problem: https://stackoverflow.com/questions/21129020/how-to-fix-unicodedecodeerror-ascii-codec-can... -- Peter -- not a MySQL/Oracle person
[22 Oct 2017 8:20]
Peter Laursen
Looks like a Python problem: https://stackoverflow.com/questions/21129020/how-to-fix-unicodedecodeerror-ascii-codec-can... -- Peter -- not a MySQL/Oracle person
[23 Oct 2017 14:40]
MySQL Verification Team
Thank you for the bug report. Please check if your password or paths has unicode symbols if yes try using only English characters. Thanks.
[24 Nov 2017 1:00]
Bugs System
No feedback was provided for this bug for over a month, so it is being suspended automatically. If you are able to provide the information that was originally requested, please do so and change the status of the bug back to "Open".
[17 Feb 2018 12:03]
Sergio Lencinas
Hi Team, The error is still occurring. The latest answer was: "Please check if your password or paths has unicode symbols if yes try using only English characters. Thanks." We are dealing here with a CSV File, no passwords or paths are inside and of course an UTF-8 Files has non english characters as those are supported by UTF-8. Trying with "English Only" is not an option. Any way to fix that ? Thanks
[21 Mar 2018 22:11]
MySQL Verification Team
Please provide the create table statement so we can test the cvs file you attached, Thanks.
[22 Apr 2018 1:00]
Bugs System
No feedback was provided for this bug for over a month, so it is being suspended automatically. If you are able to provide the information that was originally requested, please do so and change the status of the bug back to "Open".
[9 Nov 2019 9:24]
Fabian König
experiencing the exact same issue when attempting to load a csv file using the table data import wizard.
[9 Nov 2019 9:25]
Fabian König
respectively .. sorry .. it is slightly different: UnicodeDecodeError: 'ascii' codec can't decode byte 0xc2 in position 4: ordinal not in range(128) mysql workbench
Description: HI Team, I have created a CSV File with Google Sheets (UTF-8) however I get an unicode conversion error: here the log of the import: Starting... Prepare Import... Prepare Import done Import data file.... - Prepare Import Traceback (most recent call last): File "/Applications/MySQLWorkbench.app/Contents/Resources/libraries/workbench/wizard_progress_page_widget.py", line 192, in thread_work self.func() File "/Applications/MySQLWorkbench.app/Contents/Resources/plugins/sqlide_power_import_wizard.py", line 125, in start_import retval = self.module.start(self.stop) File "/Applications/MySQLWorkbench.app/Contents/Resources/plugins/sqlide_power_import_export_be.py", line 271, in start ret = self.start_import() File "/Applications/MySQLWorkbench.app/Contents/Resources/plugins/sqlide_power_import_export_be.py", line 420, in start_import query = """PREPARE stmt FROM 'INSERT INTO %s (%s) VALUES(%s)'""" % (self._table_w_prefix, ",".join(["`%s`" % col for col in dest_col_order]), ",".join(["?" for i in dest_col_order])) UnicodeDecodeError: 'ascii' codec can't decode byte 0xc3 in position 7: ordinal not in range(128) ERROR: Import data file: 'ascii' codec can't decode byte 0xc3 in position 7: ordinal not in range(128) Failed How to repeat: I can provide the csv file used to import Here the wb.log 16:47:47 [INF][ Wizard]: Execute 'Prepare Import' 16:47:47 [INF][ Wizard]: Starting thread for 'Import data file' 16:47:47 [ERR][ Wizard]: Thread 'Import data file' failed: 'ascii' codec can't decode byte 0xc3 in position 7: ordinal not in range(128) 16:48:57 [INF][ Wizard]: Execute 'Prepare Import' 16:48:57 [INF][ Wizard]: Starting thread for 'Import data file' 16:48:57 [ERR][ Wizard]: Thread 'Import data file' failed: 'ascii' codec can't decode byte 0xc3 in position 7: ordinal not in range(128)