PREHOOK: query: DESCRIBE FUNCTION unhex PREHOOK: type: DESCFUNCTION POSTHOOK: query: DESCRIBE FUNCTION unhex POSTHOOK: type: DESCFUNCTION unhex(str) - Converts hexadecimal argument to binary PREHOOK: query: DESCRIBE FUNCTION EXTENDED unhex PREHOOK: type: DESCFUNCTION POSTHOOK: query: DESCRIBE FUNCTION EXTENDED unhex POSTHOOK: type: DESCFUNCTION unhex(str) - Converts hexadecimal argument to binary Performs the inverse operation of HEX(str). That is, it interprets each pair of hexadecimal digits in the argument as a number and converts it to the byte representation of the number. The resulting characters are returned as a binary string. Example: > SELECT DECODE(UNHEX('4D7953514C'), 'UTF-8') from src limit 1; 'MySQL' The characters in the argument string must be legal hexadecimal digits: '0' .. '9', 'A' .. 'F', 'a' .. 'f'. If UNHEX() encounters any nonhexadecimal digits in the argument, it returns NULL. Also, if there are an odd number of characters a leading 0 is appended. PREHOOK: query: -- Good inputs SELECT unhex('4D7953514C'), unhex('31323637'), unhex('61'), unhex('2D34'), unhex('') FROM src tablesample (1 rows) PREHOOK: type: QUERY PREHOOK: Input: default@src #### A masked pattern was here #### POSTHOOK: query: -- Good inputs SELECT unhex('4D7953514C'), unhex('31323637'), unhex('61'), unhex('2D34'), unhex('') FROM src tablesample (1 rows) POSTHOOK: type: QUERY POSTHOOK: Input: default@src #### A masked pattern was here #### MySQL 1267 a -4 PREHOOK: query: -- Bad inputs SELECT unhex('MySQL'), unhex('G123'), unhex('\0') FROM src tablesample (1 rows) PREHOOK: type: QUERY PREHOOK: Input: default@src #### A masked pattern was here #### POSTHOOK: query: -- Bad inputs SELECT unhex('MySQL'), unhex('G123'), unhex('\0') FROM src tablesample (1 rows) POSTHOOK: type: QUERY POSTHOOK: Input: default@src #### A masked pattern was here #### NULL NULL NULL