Please enable JavaScript.
Coggle requires JavaScript to display documents.
DB-General - Coggle Diagram
DB-General
Text type
Character Sets
A character set is a collection of characters,
-
utf8
it has limitations, especially when dealing with characters outside the Basic Multilingual Plane (BMP)
-
utf8mb4
-
allowing it to represent the full range of Unicode characters, may require characters outside the BMP
Collations
how characters are compared, sorted, and indexed
Different languages have specific rules for sorting characters, handling accents, and other linguistic considerations.
Collations define these rules, and they can be case-sensitive or case-insensitive.
-
-
-