Description:
Trying to export data with umlauts causes an error in Table Data Export Wizard.
Workbench: 8.0.31
MySQL: 5.7.12
Error in the UI:
Starting...
Prepare Export...
Prepare Export done
Export data to file....
- Begin Export
- Data export
- Data export
Traceback (most recent call last):
File "/Applications/MySQLWorkbench.app/Contents/Resources/libraries/workbench/wizard_progress_page_widget.py", line 197, in thread_work
self.func()
File "/Applications/MySQLWorkbench.app/Contents/Resources/plugins/sqlide_power_export_wizard.py", line 273, in start_export
retval = self.module.start(self.stop)
File "/Applications/MySQLWorkbench.app/Contents/Resources/plugins/sqlide_power_import_export_be.py", line 302, in start
ret = self.start_export()
File "/Applications/MySQLWorkbench.app/Contents/Resources/plugins/sqlide_power_import_export_be.py", line 398, in start_export
output.writerow(row)
UnicodeEncodeError: 'ascii' codec can't encode character '\xe4' in position 6: ordinal not in range(128)
ERROR: Export data to file: 'ascii' codec can't encode character '\xe4' in position 6: ordinal not in range(128)
Failed
Error in the log:
11:23:24 [INF][ Wizard]: Execute 'Prepare Export'
11:23:24 [INF][ Wizard]: Starting thread for 'Export data to file'
11:23:24 [ERR][ Wizard]: Thread 'Export data to file' failed: 'ascii' codec can't encode character '\xe4' in position 6: ordinal not in range(128)
How to repeat:
Run the following commands:
CREATE TABLE export_test (
text varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
INSERT INTO export_test (text) VALUES ('test');
INSERT INTO export_test (text) VALUES ('test รค');
Then use the Table Data Export Wizard with default settings.
Description: Trying to export data with umlauts causes an error in Table Data Export Wizard. Workbench: 8.0.31 MySQL: 5.7.12 Error in the UI: Starting... Prepare Export... Prepare Export done Export data to file.... - Begin Export - Data export - Data export Traceback (most recent call last): File "/Applications/MySQLWorkbench.app/Contents/Resources/libraries/workbench/wizard_progress_page_widget.py", line 197, in thread_work self.func() File "/Applications/MySQLWorkbench.app/Contents/Resources/plugins/sqlide_power_export_wizard.py", line 273, in start_export retval = self.module.start(self.stop) File "/Applications/MySQLWorkbench.app/Contents/Resources/plugins/sqlide_power_import_export_be.py", line 302, in start ret = self.start_export() File "/Applications/MySQLWorkbench.app/Contents/Resources/plugins/sqlide_power_import_export_be.py", line 398, in start_export output.writerow(row) UnicodeEncodeError: 'ascii' codec can't encode character '\xe4' in position 6: ordinal not in range(128) ERROR: Export data to file: 'ascii' codec can't encode character '\xe4' in position 6: ordinal not in range(128) Failed Error in the log: 11:23:24 [INF][ Wizard]: Execute 'Prepare Export' 11:23:24 [INF][ Wizard]: Starting thread for 'Export data to file' 11:23:24 [ERR][ Wizard]: Thread 'Export data to file' failed: 'ascii' codec can't encode character '\xe4' in position 6: ordinal not in range(128) How to repeat: Run the following commands: CREATE TABLE export_test ( text varchar(255) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; INSERT INTO export_test (text) VALUES ('test'); INSERT INTO export_test (text) VALUES ('test รค'); Then use the Table Data Export Wizard with default settings.