search

kristijanhusak / vim-dadbod-ui

Simple UI for https://github.com/tpope/vim-dadbod
MIT License
1.54k stars 94 forks source link

Replace binary values in output #200

Closed shaunmolloy closed 1 year ago

shaunmolloy commented 1 year ago

Binary column values appear corrupt in the output.

How about replacing those values in the output with an empty value, to clean up the view?

kristijanhusak commented 1 year ago

Output is controlled by cli used behind the scenes, which is mysql here. You can try to convert it to hex with this https://stackoverflow.com/a/46418613, but I didn't test it.

shaunmolloy commented 1 year ago

Thanks @kristijanhusak for the fast reply. That solves the issue :+1: I'll close this.

Added the following to /etc/my.cnf:

[mysql]
binary-as-hex = true