A

Admin • 833K Points
Coach

Q. What is the maximum collations a character set can have?

  • (A) more than 1
  • (B) 2
  • (C) 1
  • (D) 0
  • Correct Answer - Option(A)
  • Views: 32
  • Filed under category MySQL
  • Hashtags:

Explanation by: Admin

In MySQL, a single character set can have multiple collations associated with it. A collation defines how strings are compared and sorted within that character set, taking into account factors like case sensitivity and accent sensitivity.

For example:

  • The utf8 character set has several collations, such as:
    • utf8_general_ci (case-insensitive, accent-insensitive)
    • utf8_unicode_ci (case-insensitive, accent-insensitive, but with more accurate sorting rules for various languages)
    • utf8_bin (case-sensitive, binary comparison)

Thus, a single character set can have multiple collations, which is why the correct answer is (A) more than 1.

You must be Logged in to update hint/solution

Discusssion

Login to discuss.

Be the first to start discuss.