MariaDB are bitwise operators defined on strings?

0 votes

1 answer

621 views

mariadb string operator bit-manipulation

                          Is the behavior of BITAND, (*bitwise and*) defined in MariaDB over strings?

    SELECT '0011' & '0011', 'ff' & 'ff', 'yy' & 'YY', '5' & '5';
    +-----------------+-------------+-------------+-----------+
    | '0011' & '0011' | 'ff' & 'ff' | 'yy' & 'YY' | '5' & '5' |
    +-----------------+-------------+-------------+-----------+
    |              11 |           0 |           0 |         5 |
    +-----------------+-------------+-------------+-----------+

I'm just wondering what is exactly happening here.
                        

Asked by Evan Carroll (65502 rep)

Apr 24, 2018, 05:30 PM
Last activity: May 2, 2018, 06:29 PM

MariaDB are bitwise operators defined on strings?

Related Questions