Utf8_bin, utf8_general_cs, and utf8_bin encoded by utf8 in MySQL

Utf8_bin, utf8_general_cs, and utf8_bin encoded by utf8 in MySQL

SubmittedShq6.

On 2008, November 6, am. Technical article

Utf8_general_ci is case-insensitive. you need to use it when registering your username and email address.

Utf8_general_cs is case sensitive. If the user name and email address are used, this will lead to adverse consequences.

Utf8_bin: compare strings by the binary value of each character in the string to compile and store each string in binary data. Case Sensitive and binary content can be saved

Example:

If your SQL query statement: Where first_name = "Bob"
Which of the following fields will return a match:
'Bob': utf8_bin, utf8_general_ci and utf8_general_cs
'B? B ': utf8_general_ci and utf8_general_cs will? Convert to o
'B? B ': utf8_general_ci is case insensitive