©SQL :: Manager
HomeProgram InformationTechnical detailsFree downloadDonate for a cup of coffee
myway SQL Manager for MySQL and MariaDB, Download on Uptodown
SQL functionMySQLMariaDB

The CONV SQL Function in MySQL and MariaDB - Convert numbers

CONVSyntax:CONV(Value, from Base, to Base)
Return value:CHAR
Function type:Conversion function
Function Description

The CONV() function converts numbers between different number systems.

CONV() returns a string of "Value" converted "from Base" "to Base".

If "Value" is NULL, or if "from Base" or "to Base" are invalid, CONV() returns NULL back.

The minimum base is 2 and the maximum base is 36.

Similar fixed base functions are: BIN(), OCT(), HEX() and UNHEX().

The "Value" argument is interpreted as an integer, but can also be specified as a character string.

If "Value" is not an integer, 0 is returned.

If "to Base" is a negative number, "Value" is considered a signed number, otherwise unsigned.

CONV() works with 64-bit precision.


Specifying hexadecimal and binary literal values in argument ​​only works to a limited extent in MariaDB:

0xffff doesn't work, but 0xffff + 0 does. See also examples.

Examples running on MariaDB 10.5

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25

select conv(10, 10, 16);
select conv(10, 10, 8);
select conv(10, 10, 4);
select conv(10, 10, 2);
select conv('10', 10, 2);

select conv(-10, 10, 8);
select conv(-10, 10, -8);

select conv('ff', 16, 10);
select conv('ff00', 16, 10);
select conv('1111', 2, 10);
select conv('1111', 2, 16);

select conv(0xff00, 10, 10);      /* works not in MariaDB*/
select conv(0xff00 + 0, 10, 10);  /* works */

select conv(0b1111, 10, 10);      /* works not in MariaDB*/
select conv(0b1111 + 0, 10, 10);  /* works */

select conv('test', 10, 2);
select conv(null, 10, 2);
select conv(10, 10, 1);

conv(10, 10, 16)
varchar(64) BINARY
A
conv(10, 10, 8)
varchar(64) BINARY
12
conv(10, 10, 4)
varchar(64) BINARY
22
conv(10, 10, 2)
varchar(64) BINARY
1010
conv('10', 10, 2)
varchar(64) BINARY
1010
conv(-10, 10, 8)
varchar(64) BINARY
1777777777777777777766
conv(-10, 10, -8)
varchar(64) BINARY
-12
conv('ff', 16, 10)
varchar(64) BINARY
255
conv('ff00', 16, 10)
varchar(64) BINARY
65280
conv('1111', 2, 10)
varchar(64) BINARY
15
conv('1111', 2, 16)
varchar(64) BINARY
F
conv(0xff00, 10, 10)
varchar(64) BINARY
0
conv(0xff00 + 0, 10, 10)
varchar(64) BINARY
65280
conv(0b1111, 10, 10)
varchar(64) BINARY
0
conv(0b1111 + 0, 10, 10)
varchar(64) BINARY
15
conv('test', 10, 2)
varchar(64) BINARY
0
conv(null, 10, 2)
varchar(64) BINARY
NULL
conv(10, 10, 1)
varchar(64) BINARY
NULL

Examples running on MySQL 8.0.23

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25

select conv(10, 10, 16);
select conv(10, 10, 8);
select conv(10, 10, 4);
select conv(10, 10, 2);
select conv('10', 10, 2);

select conv(-10, 10, 8);
select conv(-10, 10, -8);

select conv('ff', 16, 10);
select conv('ff00', 16, 10);
select conv('1111', 2, 10);
select conv('1111', 2, 16);

select conv(0xff00, 10, 10);      /* works on MySQL 8.0 */
select conv(0xff00 + 0, 10, 10);  /* works */

select conv(0b1111, 10, 10);      /* works on MySQL 8.0 */
select conv(0b1111 + 0, 10, 10);  /* works */

select conv('test', 10, 2);
select conv(null, 10, 2);
select conv(10, 10, 1);

conv(10, 10, 16)
varchar(65) BINARY
A
conv(10, 10, 8)
varchar(65) BINARY
12
conv(10, 10, 4)
varchar(65) BINARY
22
conv(10, 10, 2)
varchar(65) BINARY
1010
conv('10', 10, 2)
varchar(65) BINARY
1010
conv(-10, 10, 8)
varchar(65) BINARY
1777777777777777777766
conv(-10, 10, -8)
varchar(65) BINARY
-12
conv('ff', 16, 10)
varchar(65) BINARY
255
conv('ff00', 16, 10)
varchar(65) BINARY
65280
conv('1111', 2, 10)
varchar(65) BINARY
15
conv('1111', 2, 16)
varchar(65) BINARY
F
conv(0xff00, 10, 10)
varchar(65) BINARY
65280
conv(0xff00 + 0, 10, 10)
varchar(65) BINARY
65280
conv(0b1111, 10, 10)
varchar(65) BINARY
15
conv(0b1111 + 0, 10, 10)
varchar(65) BINARY
15
conv('test', 10, 2)
varchar(65) BINARY
0
conv(null, 10, 2)
varchar(65) BINARY
NULL
conv(10, 10, 1)
varchar(65) BINARY
NULL
The examples were created with the MyWAY SQL manager: Download

How to use the CONV() function in MySQL and MariaDB databases

The CONV() function in MySQL and MariaDB is used to convert a number from a numeric base to another by specifying the input value, the base of the input value, and the base to convert the value to. The result is returned as a string. The function supports various numeric systems, including binary (base 2), octal (base 8), decimal (base 10) and hexadecimal (base 16). The function supports conversions between bases 2 to 36 and can, for example, work with binary or hexadecimal representations of data. Various applications are enabled, such as basic conversion, binary data manipulation, encoding and decoding and display formatting.
CONCATCONCAT_WSCONNECTION_IDCONVCONVERTCONVERT_TZCOS

Further MySQL und MariaDB SQL Conversion functions

BINBIN(Integer)
More about BIN Function

CASTCAST(Value AS Type)
More about CAST Function

CONVERTCONVERT(Expression [, in type] [, or character set])
More about CONVERT Function

HEXHEX(Integer or 'string')
More about HEX Function

OCTOCT(Integer)
More about OCT Function

UNHEXUNHEX(String)
More about UNHEX Function

Numeric functionsString functionsRegular ExpressionsDate and Time functions
Comparison functionsEncryption & CompressionConversion functionsNULL functions
Aggregate functionsWindow functionsJSON functionsGeometric functions
Sequence functionsInformation functionsDynamic ColumnsMiscellaneous functions
More information about the CONV SQL function: mysql.com and mariadb.com and w3schools.com
Updated: 2023-09-24ImprintContactTerms & conditionsPrivacy & CookiesUpdatesSitemapFacebookLinkedinTwitterStatistics©2020-2024 Heino Cunze-Fischer