UUID vs binary(16)

对于dtle.gtid_executed表中的source_uuid binary(16), 在binlog中以string类型表达

columntype 254 MYSQL_TYPE_STRING

binlog储存binary时, 会忽略结尾的0.

The use of CHARACTER SET binary in the definition of a CHAR, VARCHAR, or TEXT column causes the column to be treated as a binary data type. For example, the following pairs of definitions are equivalent:

CHAR(10) CHARACTER SET binary
BINARY(10)

VARCHAR(10) CHARACTER SET binary
VARBINARY(10)

TEXT CHARACTER SET binary
BLOB

https://github.com/go-mysql-org/go-mysql/issues/ 477