MySQL Bugs: #104341: i get an error in data transfer

Bug #104341	i get an error in data transfer
Submitted:	16 Jul 2021 14:06	Modified:	16 Aug 2021 13:05
Reporter:	ester cohen	Email Updates:
Status:	Can't repeat	Impact on me:	None
Category:	MySQL Workbench: Migration	Severity:	S3 (Non-critical)
Version:	the latest	OS:	Windows
Assigned to:		CPU Architecture:	Any

Description:

I try to convert mmsql to MySQL with MySQL workbench and I got this log

Starting...
Prepare information for data copy...
Prepare information for data copy done
Determine number of rows to copy....
Counting number of rows in tables...
wbcopytables.exe --count-only --passwords-from-stdin --odbc-source="DRIVER={SQL Server};SERVER=******;DATABASE={};UID=**" --source-rdbms-type=Mssql --source-timeout= --target-timeout=None --table-file=D:\Users\מנהל\AppData\Local\Temp\tmp_vvfup8z
ERROR: Determine number of rows to copy: 'utf-8' codec can't decode byte 0xee in position 45: invalid continuation byte
Failed

How to repeat:
Migrate a .mdf sql server database to MySQL .

Hello ester cohen,

Thank you for the bug report.
I tried to reproduce your issue on windows 10 with workbench 8.0.26 but I am not seeing any issues at my end. 

Regards,
Ashwini Patil

I was transfering database to another server, when I got the same error:
Traceback (most recent call last):
  File "C:\Program Files\MySQL\MySQL Workbench 8.0\modules\db_copy_progress.py", line 155, in thread_work
    self.func()
  File "C:\Program Files\MySQL\MySQL Workbench 8.0\modules\db_copy_progress.py", line 641, in _row_count
    total = self._transferer.count_table_rows(self._working_set)
  File "C:\Program Files\MySQL\MySQL Workbench 8.0\modules\DataMigrator.py", line 274, in count_table_rows
    if e:
UnicodeDecodeError: 'utf-8' codec can't decode byte 0xf1 in position 1186: invalid continuation byte
ERROR: Counting table rows to copy: 'utf-8' codec can't decode byte 0xf1 in position 1186: invalid continuation byte
Failed