Binary Character String Comparison : Binary « String « SQL / MySQL






  1. SQL / MySQL
  2. String
  3. Binary

Binary Character String Comparison

      
mysql>
mysql> SELECT 'a'='A', BINARY 'a' = 'A', 'a' = BINARY 'A';
+---------+------------------+------------------+
| 'a'='A' | BINARY 'a' = 'A' | 'a' = BINARY 'A' |
+---------+------------------+------------------+
|       1 |                0 |                0 |
+---------+------------------+------------------+
1 row in set (0.00 sec)

mysql>
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.Get the decimal values that belong to the binary representations 1001 and 111.
9.Controlling Case Sensitivity of String Sorts
10.Mix binary and nonbinary string columns within a single table.