MariaDB BINARYで文字列をバイナリ文字列にキャストする
環境
Windows 10 Home 64bit
MariaDB 10.6.4
構文
BINARY expr
BINARY 演算子は、式をバイナリ文字列 (binary 文字セットおよび binary 照合順序を持つ文字列) に変換します。
使用例
SQL構文1
SELECT 'b' = 'B';
SELECT 'b' = 'B';
SELECT 'b' = 'B';
結果
MariaDB [(none)]> SELECT 'b' = 'B';
+-----------+
| 'b' = 'B' |
+-----------+
| 1 |
+-----------+
1 row in set (0.055 sec)
MariaDB [(none)]> SELECT 'b' = 'B';
+-----------+
| 'b' = 'B' |
+-----------+
| 1 |
+-----------+
1 row in set (0.055 sec)
MariaDB [(none)]> SELECT 'b' = 'B'; +-----------+ | 'b' = 'B' | +-----------+ | 1 | +-----------+ 1 row in set (0.055 sec)
SQL構文2
SELECT BINARY 'a’ = 'A’;
結果
MariaDB [(none)]> SELECT BINARY 'a' = 'A';
+------------------+
| BINARY 'a' = 'A' |
+------------------+
| 0 |
+------------------+
1 row in set (0.039 sec)
MariaDB [(none)]> SELECT BINARY 'a' = 'A';
+------------------+
| BINARY 'a' = 'A' |
+------------------+
| 0 |
+------------------+
1 row in set (0.039 sec)
MariaDB [(none)]> SELECT BINARY 'a' = 'A'; +------------------+ | BINARY 'a' = 'A' | +------------------+ | 0 | +------------------+ 1 row in set (0.039 sec)