Get the decimal values that belong to the binary representations 1001 and 111. : Binary « String « SQL / MySQL






  1. SQL / MySQL
  2. String
  3. Binary

Get the decimal values that belong to the binary representations 1001 and 111.

       
mysql>
mysql>
mysql> SELECT CONV(1001,2,10), CONV(111,2,10);
+-----------------+----------------+
| CONV(1001,2,10) | CONV(111,2,10) |
+-----------------+----------------+
| 9               | 7              |
+-----------------+----------------+
1 row in set (0.00 sec)

mysql>








Related examples in the same category

1.Using Binary with REGEXP
2.Force name values to be case sensitive using BINARY
3.Using BINARY has the effect of causing [:lower:] and [:upper:] in regular expressions to act as you would expe
4.A pattern match against a binary column is case sensitive.
5.Convert the output column to binary and sort that
6.To make tstr case sensitive, use BINARY:
7.Get the binary representation of the values 6 and 10.
8.Binary Character String Comparison
9.Controlling Case Sensitivity of String Sorts
10.Mix binary and nonbinary string columns within a single table.