Entering Binary Numbers in MySQL

Q

How To Enter Binary Numbers in SQL Statements in MySQL?

✍: FYIcenter.com

A

If you want to enter character strings or numeric values as binary numbers, you can quote binary numbers with single quotes and a prefix of (B), or just prefix binary numbers with (0b). Binary numbers will be automatically converted into character strings or numeric values based on the expression contexts. Here are some good examples:

SELECT B'010000010100001001000011' FROM DUAL;
   ABC

SELECT 0b1000 + 0 FROM DUAL;
   8

⇒ Entering Boolean Values in MySQL

⇐ Entering Numeric Values as HEX Numbers in MySQL

⇑ Introduction to SQL Basics in MySQL

⇑⇑ MySQL Database Tutorials

2018-03-31, 2811🔥, 0💬