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

1.	Aggregate Functions
2.	Backup Load
3.	Command MySQL
4.	Cursor
5.	Data Type
6.	Database
7.	Date Time
8.	Engine
9.	Event
10.	Flow Control
11.	FullText Search
12.	Function
13.	Geometric
14.	I18N
15.	Insert Delete Update
16.	Join
17.	Key
18.	Math
19.	Procedure Function
20.	Regular Expression
21.	Select Clause
22.	String
23.	Table Index
24.	Transaction
25.	Trigger
26.	User Permission
27.	View
28.	Where Clause
29.	XML

SQL / MySQL » String » 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

java2s.com | Contact Us | Privacy Policy

All other trademarks are property of their respective owners.