With Mysql – Return the output of AES_ENCRYPT as string “0x8DBADD…”
Posted By: Anonymous In Mysql the function AES_ENCRYPT() returns a hex like: 0x8DBADD32FD0FAB62232104DEB9D56246 How can I return it as string: "0x8DBADD32FD0FAB62232104DEB9D56246" so for example I can right() to remove the first two characters: "0x" I tried CAST but that converts the HEX to string. What I need is the string literal of the Hex Solution …