Bug #84497 Encoding Error during migration from PostgreSQL database with Japanese Character

Submitted: 13 Jan 2017 3:36 Modified: 24 Jul 2018 15:06
Reporter: SChedule Smasher Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Workbench: Migration Severity:S2 (Serious)
Version:8.3 OS:Windows (10)
Assigned to: CPU Architecture:Any

[13 Jan 2017 3:36] SChedule Smasher
Description:
So far I've tried adding the encoding to my ODBC connection string with no luck. 

I get the error:   Traceback (most recent call last): File "C:\Program Files\MySQL\MySQL Workbench 6.3 CE\workbench\wizard_progress_page_widget.py", 
  line 192, in thread_work self.func() File "C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\migration_schema_selection.py", 
  line 175, in task_reveng self.main.plan.migrationSource.reverseEngineer() File "C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\migration.py", 
  line 369, in reverseEngineer self.state.sourceCatalog = self._rev_eng_module.reverseEngineer(self.connection, self.selectedCatalogName, self.selectedSchemataNames, self.state.applicationData) SystemError: DataError("('22P05', '[22P05] ERROR: character with byte sequence 0xe3 0x81 0x82 in encoding "UTF8" has no equivalent in encoding "WIN1252";\nError while executing the query (7) (SQLExecDirectW)')"): error calling Python module function DbPostgresqlRE.reverseEngineer ERROR: Reverse engineer selected schemas: DataError("('22P05', '[22P05] ERROR: character with byte sequence 0xe3 0x81 0x82 in encoding "UTF8" has no equivalent in encoding "WIN1252";\nError while executing the query (7) (SQLExecDirectW)')"): error calling Python module function DbPostgresqlRE.reverseEngineer Failed

How to repeat:
Try importing a UTF database with Japanese Characters from PostgreSQL

Suggested fix:
Allow the user to specify the client encoding
[13 Jan 2017 3:44] SChedule Smasher
Looks like others have had related issues:

http://stackoverflow.com/questions/22688064/ms-sql-to-mysql-transition-using-workbench-err...
[24 Jun 2018 15:06] MySQL Verification Team
Please try development version 8.0.11 rc. Thanks.
[25 Jul 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".

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.052 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.