database:mysql:set-character-set-collation
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revision | |||
database:mysql:set-character-set-collation [2023/08/31 23:56] – [View existing character set and collation for a specific table] odefta | database:mysql:set-character-set-collation [2023/08/31 23:56] (current) – [View existing character set and collation for a specific table] odefta | ||
---|---|---|---|
Line 31: | Line 31: | ||
< | < | ||
- | **Collation** refers to a set of rules that determine how characters in character sets are compared and sorted. \\ These rules affect the results of data retrieval when the **ORDER BY, GROUP BY, LIKE**, and other SQL clauses are used. Collations also affect operations like **string comparison** ( =, <>, <, <= , >, >= ) | + | **Collation** refers to a set of rules that determine how characters in character sets are compared and sorted. \\ These rules affect the results of data retrieval when the **ORDER BY, GROUP BY, LIKE**, and other SQL clauses are used. Collations also affect operations like **string comparison** ( =, <>, <, <=, >, >= ) |
</ | </ | ||
database/mysql/set-character-set-collation.1693515369.txt.gz · Last modified: 2023/08/31 23:56 by odefta