fields with varbinary are displayed with hex() function
Database management in a single PHP file
Brought to you by:
jakubvrana
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;
varbinary
could contain binary data. If it contains a string, change the schama tovarchar
.