schemasync針對簡體中文或latin1產生亂碼

[te87037]

Traceback (most recent call last):
File "/opt/venv4archery/bin/schemasync", line 8, in
sys.exit(main())
File "/opt/venv4archery/lib/python3.9/site-packages/schemasync/schemasync.py", line 347, in main
sys.exit(parse_cmd_line(app)())
File "/opt/venv4archery/lib/python3.9/site-packages/schemasync/schemasync.py", line 133, in processor
return fn(*args, **dict(version_filename=options.version_filename,
File "/opt/venv4archery/lib/python3.9/site-packages/schemasync/schemasync.py", line 273, in app
for patch, revert in syncdb.sync_schema(source_obj.selected,
File "/opt/venv4archery/lib/python3.9/site-packages/schemasync/syncdb.py", line 34, in sync_schema
for p, r in sync_dropped_tables(fromdb.tables, todb.tables,
File "/opt/venv4archery/lib/python3.9/site-packages/schemasync/syncdb.py", line 189, in sync_dropped_tables
p, r = to_tables[t].drop(), to_tables[t].create()
File "/opt/venv4archery/lib/python3.9/site-packages/schemaobject/table.py", line 206, in create
result = cursor.execute("SHOW CREATE TABLE `%s`.`%s`" % (self.parent.name, self.name))
File "/opt/venv4archery/lib/python3.9/site-packages/schemaobject/connection.py", line 85, in execute
cursor.execute(sql, values)
File "/opt/venv4archery/lib/python3.9/site-packages/pymysql/cursors.py", line 170, in execute
result = self._query(query)
File "/opt/venv4archery/lib/python3.9/site-packages/pymysql/cursors.py", line 328, in _query
conn.query(q)
File "/opt/venv4archery/lib/python3.9/site-packages/pymysql/connections.py", line 517, in query
self._affected_rows = self._read_query_result(unbuffered=unbuffered)
File "/opt/venv4archery/lib/python3.9/site-packages/pymysql/connections.py", line 732, in _read_query_result
result.read()
File "/opt/venv4archery/lib/python3.9/site-packages/pymysql/connections.py", line 1082, in read
self._read_result_packet(first_packet)
File "/opt/venv4archery/lib/python3.9/site-packages/pymysql/connections.py", line 1152, in _read_result_packet
self._read_rowdata_packet()
File "/opt/venv4archery/lib/python3.9/site-packages/pymysql/connections.py", line 1190, in _read_rowdata_packet
rows.append(self._read_row_from_packet(packet))
File "/opt/venv4archery/lib/python3.9/site-packages/pymysql/connections.py", line 1206, in _read_row_from_packet
data = data.decode(encoding)
UnicodeDecodeError: 'utf-8' codec can't decode byte 0xb3 in position 984: invalid start byte

手動執行依然錯誤，測試後需要加上charset=utf8mb4，即可正常執行操作

[LeoQuote]

可以跟 schemasync 提 issue , 或更新我们的 wiki, 让后面的用户注意此类错误.

[te87037]

這是archey執行時沒有指定charset產生的問題
並不是schemasync的狀況
稍後我提交一個PR，將charset參數帶入