What is the default type of a bit value assigned to user variables?

MySQLMySQLi Database

By default, the bit values assigned to the user variables are binary strings. It can be illustrated by assigning the bit value to a user variable and then by retrieving them as follows −

mysql> SET @abc = 0b1000011;
Query OK, 0 rows affected (0.00 sec)

mysql> Select @abc;
+------+
| @abc |
+------+
| C    |
+------+
1 row in set (0.00 sec)

The above result set shows that the default type of a bit value assigned to user variables are binary strings.

raja
Published on 21-Feb-2018 12:33:11
Advertisements