What MySQL returns if we convert an empty hexadecimal value to a number?

As we know that an empty hexadecimal value is a zero-length binary string hence if 0 is added to it then the result would be 0. In other words, we can say that if we convert an empty hexadecimal value to a number then it produces 0. The following query will make it understand −

mysql> SELECT X''+ 0;
+--------+
| X''+ 0 |
+--------+
| 0      |
+--------+
1 row in set (0.15 sec)

Rishi Raj

Published on 20-Feb-2018 13:23:41

• Related Questions & Answers
• How MySQL evaluates an empty hexadecimal value?
• What MySQL returns if I provide a non-hexadecimal number as an argument to UNHEX() function?
• What MySQL returns if we provide value larger than 255 as argument to MySQL CHAR() function?
• What MySQL returns if we provide an empty string for padding with other string in LPAD() or RPAD() functions?
• How can we convert a hexadecimal value to a byte in Java?
• Convert a Number to Hexadecimal in C++
• What MySQL returns if I insert invalid value into ENUM?
• What MySQL ELT() function returns if we the index number, provided as an argument, is less than 1?
• What MySQL returns if we use UNIX_TIMESTAMP() function with no argument?
• What MySQL returns when we alter AUTO_INCREMENT value which is less than current sequence number?
• 8086 program to convert an 8 bit BCD number into hexadecimal number
• Java program to convert decimal number to hexadecimal number
• Java Program to convert hexadecimal number to decimal number
• What happens if we eat two bananas on an empty stomach?
• What MySQL returns if we include time components along with date component as an argument to DATEDIFF() function?