Mix binary and nonbinary string columns within a single table. : Binary « String « SQL / MySQL






  1. SQL / MySQL
  2. String
  3. Binary

Mix binary and nonbinary string columns within a single table.

      
mysql>
mysql> CREATE TABLE auth_info
    -> (
    ->     login    CHAR(16),          # not case sensitive
    ->     password CHAR(16) BINARY    # case sensitive
    -> );
Query OK, 0 rows affected (0.00 sec)

mysql>
mysql> drop table auth_info;
Query OK, 0 rows affected (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.Binary Character String Comparison
10.Controlling Case Sensitivity of String Sorts