Menu

#528 fields with varbinary are displayed with hex() function

Git
closed-rejected
nobody
None
5
2017-02-19
2017-02-08
No

Currently i try to manage a SabreDAV MySQL DB with Adminer 4.2.5. A lot of the fields are defined as varbinary. If i try t get the Data for such a table, the select comes back with:

SELECT *, HEX(uri) AS uri, HEX(email) AS email FROM principals LIMIT 50

but it should be without the Hex Function like SELECT * FROM principals LIMIT 50;

Discussion

  • Jakub Vrána

    Jakub Vrána - 2017-02-19
    • status: open --> closed-rejected
     
  • Jakub Vrána

    Jakub Vrána - 2017-02-19

    varbinary could contain binary data. If it contains a string, change the schama to varchar.

     

Log in to post a comment.

Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.