Do we have any lower and upper limit of base in MySQL CONV() function? What happens if out of limit base is provided in CONV() function?

The base must be greater than 2 and less than 36 i.e. the lower limit of a base is 2 and the upper limit is 36. It is applied to both from_base and to_base values. If in case we provide out of limit values of the base then MySQL returns NULL as the output. Following example will demonstrate it −

Example

mysql> Select CONV(10,10,38);

+----------------+
| CONV(10,10,38) |
+----------------+
| NULL           |
+----------------+

1 row in set (0.00 sec)

mysql> Select CONV(10,72,2);

+---------------+
| CONV(10,72,2) |
+---------------+
| NULL          |
+---------------+

1 row in set (0.00 sec)

mysql> Select CONV(10,10,1);

+---------------+
| CONV(10,10,1) |
+---------------+
| NULL          |
+---------------+

1 row in set (0.00 sec)

Ankith Reddy

Updated on 04-Feb-2020 05:56:40

• Related Questions & Answers
• What happens if a NULL argument is provided in MySQL CONV() function?
• What happens if the value of number ‘N’ in CONV() function is not as per accordance with its base?
• What is MySQL HEX() function and how it is different from CONV() function?
• What happens if the position of insertion, in MySQL INSERT() function, is out of range?
• What is the limit of auto_increment (integer) in MySQL?
• What will happen if the MySQL AUTO_INCREMENT column reaches the upper limit of the data type?
• What MySQL EXPORT_SET() function returns if any of the argument is NULL?
• What is the use of the LIMIT keyword in MySQL query?
• What happens if we provide NULL as an argument to MySQL CHAR() function?
• What MySQL returns if the search string, provided in FIELD() function, is NULL?
• What MySQL ASCII() function returns if no parameter is provided to it?
• What MySQL CHAR_LENGTH() function returns if no parameter is provided to it?
• What would be the effect on MySQL output if we have the combination of NULL and other values in the list of strings, provided as arguments in FIELD() function?
• What happens if I will use integer values as arguments of MySQL LOCATE() function?
• What MySQL ELT() function returns if we the index number, provided as an argument, is less than 1?