collation in sql code example

Example 1: best sql collation

utf8_general_ci

Example 2: collation in sql

Collation is defined as a set of rules
that determine how data can be sorted as
well as compared. Character data is sorted
using the rules that define the correct
character sequence along with options for 
specifying case-sensitivity, character width etc.