

- Trending Categories
Data Structure
Networking
RDBMS
Operating System
Java
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
What MySQL returns if I provide a non-hexadecimal number as an argument to UNHEX() function?
MySQL returns NULL if we provide any non-hexadecimal number as an argument to UNHEX() function. Following example will demonstrate it.
Example
mysql> Select UNHEX('ANK96598'); +-------------------+ | UNHEX('ANK96598') | +-------------------+ | NULL | +-------------------+ 1 row in set (0.00 sec)
As we know that the valid hexadecimal digits are between ‘0…9’, ‘A…F’ or ‘a…f’ hence the above query returns NULL.
- Related Questions & Answers
- What MySQL returns if we provide value larger than 255 as argument to MySQL CHAR() function?
- What happens if we provide NULL as an argument to MySQL CHAR() function?
- What MySQL ASCII() function returns if I will provide NULL to it?
- What MySQL returns if we convert an empty hexadecimal value to a number?
- What MySQL ELT() function returns if we the index number, provided as an argument, is less than 1?
- What MySQL returns on passing an invalid string as an argument to STR_TO_DATE() function?
- What MySQL ELT() function returns if the index number, provided as an argument, is higher than the number of strings?
- What MySQL returns if we include time components along with date component as an argument to DATEDIFF() function?
- What MySQL returns if we include date components along with time component as an argument to TIMEDIFF() function?
- How can I use a SELECT statement as an argument of MySQL IF() function?
- What MySQL returns if the argument of QUOTE() function is NULL?
- What MySQL returns if we use UNIX_TIMESTAMP() function with no argument?
- What MySQL COALESCE() function returns if it has a blank, but not NULL, as the first argument?
- What MySQL returns if the list of strings, provided as argument in FIELD() function, are NULL?
- What MySQL returns if the first argument of INTERVAL() function is NULL?
Advertisements