表中包含binary字段的问题

[qq122356]

MYSQL 版本 8.0.23
表中包含一binary的列，报如下错误：
Traceback (most recent call last):
File "binlog2sql.py", line 150, in
binlog2sql.process_binlog()
File "binlog2sql.py", line 106, in process_binlog
sql = concat_sql_from_binlog_event(cursor=cursor, binlog_event=binlog_event, no_pk=self.no_pk,
File "/opt/binlog2sql/binlog2sql/binlog2sql_util.py", line 177, in concat_sql_from_binlog_event
pattern = generate_sql_pattern(binlog_event, row=row, flashback=flashback, no_pk=no_pk)
File "/opt/binlog2sql/binlog2sql/binlog2sql_util.py", line 241, in generate_sql_pattern
return {'template': template, 'values': list(values)}
File "/opt/binlog2sql/binlog2sql/binlog2sql_util.py", line 142, in fix_object
return value.decode('utf-8')
UnicodeDecodeError: 'utf-8' codec can't decode byte 0xeb in position 1: invalid continuation byte

[michael-liumh]

binary 列转成十六进制就行

[michael-liumh]

可以将 blob 转成十六进制值，我改了一版，已经支持了，你可以试试：
https://github.com/michael-liumh/binlog2sql.git

[qq122356]

可以将 blob 转成十六进制值，我改了一版，已经支持了，你可以试试： https://github.com/michael-liumh/binlog2sql.git

收到回复后，第一时间测试了下，可以恢复了，感谢