Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

[ 功能建议 ] Binary 数据类型支持显示为原本的HEX字符串 #1772

Closed
LeoQuote opened this issue Aug 15, 2022 Discussed in #1766 · 0 comments
Closed

[ 功能建议 ] Binary 数据类型支持显示为原本的HEX字符串 #1772

LeoQuote opened this issue Aug 15, 2022 Discussed in #1766 · 0 comments
Labels
ease of use enhancement New feature or request

Comments

@LeoQuote
Copy link
Collaborator

Discussed in #1766

Originally posted by beebird August 12, 2022

  • Binary data 显示的不具有可读性:
 select id, uid, account from `table1` order by id limit 1;
2 | 000001  | �yû÷¼þ�.F§�	¼§Ý�æ�
  • 目前只能通过 HEX 函数:
 select id, uid, HEX(account) from `table1` order by id limit 1;
2 | 000001 | 9D79FAF7BCFE122E46A81809C2BCA7A3FD8BE681

如果可以默认将 Binary 格式的HEX 数据,以可读的形式显示出来,就是一个很受欢迎的feature了。哪怕只支持少数数据库。

参考:

@LeoQuote LeoQuote added enhancement New feature or request ease of use labels Aug 15, 2022
hhyo added a commit that referenced this issue Sep 19, 2022
* mysql查询支持将Binary格式转换为HEX展示 #1772
@hhyo hhyo closed this as completed Sep 27, 2022
nick2wang pushed a commit to nick2wang/Archery that referenced this issue Nov 8, 2022
* mysql查询支持将Binary格式转换为HEX展示 hhyo#1772

(cherry picked from commit 18a1b33)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
ease of use enhancement New feature or request
Projects
None yet
Development

No branches or pull requests

2 participants