1.

What is character set in MySQL. What is the default character set in MySQL

Answer»

A character set is a set of symbols and encodings. A collation is a set of RULES for comparing characters in a character set
To display the available character SETS run the below query

>SHOW CHARACTER SET;

MySQL is capable of doing these things 

  1. Store strings using a variety of character sets.

  2. Compare strings using a variety of COLLATIONS.

  3. Mix strings with different character sets or collations in the same SERVER, the same database, or even the same table.

  4. Enable specification of character set and collation at any level.

Latin1 is the default character set in MySQL


Discussion

No Comment Found

Related InterviewSolutions