ShardingSphere-Proxy MySQL replied incorrect binary flags in column definition

[TeslaCN]

Bug Report

Which version of ShardingSphere did you use?

947c8c4

Which project did you use? ShardingSphere-JDBC or ShardingSphere-Proxy?

ShardingSphere-Proxy MySQL

Expected behavior

MySQL:

Actual behavior

ShardingSphere-Proxy MySQL:

Steps to reproduce the behavior, such as: SQL to execute, sharding rule configuration, when exception occur etc.

select _binary'abc', X'20', X'41'

[TeslaCN]

I found set binary flag (0x80) cannot fix this issue. The root cause of the display problem probably relates to collation. But Proxy cannot retrieve field's collation via JDBC.

From MySQL:

From Proxy:

[TeslaCN]

The binary flag is corrected. But the issue still exists.