{"id":163522,"date":"2026-06-10T16:58:44","date_gmt":"2026-06-10T16:58:44","guid":{"rendered":"https:\/\/digitionary.com\/dictionnaire\/interclassification\/"},"modified":"2026-06-10T18:20:57","modified_gmt":"2026-06-10T18:20:57","slug":"interclassification","status":"publish","type":"dictionnaire-dico","link":"https:\/\/digitionary.com\/en\/dictionnaire\/interclassification\/","title":{"rendered":"Interclassification"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">When creating a database, choosing the character collation is a key decision. This collation defines how comparisons between two strings will be performed, as well as the order in which data should be presented when displayed alphabetically.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">There are different types of collations. For example, &#8220;_ci&#8221; indicates a case-insensitive collation, meaning it ignores differences between uppercase and lowercase letters when comparing data. On the other hand, the &#8220;unicode&#8221; collation is based on the Unicode standard for a single sort, while the &#8220;general&#8221; collation offers a simplified sorting method.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">In short, the choice of character collation is crucial in setting up a database, influencing how data will be compared and ordered within the system.<\/p>\n","protected":false},"template":"","categories-glossary":[313],"class_list":["post-163522","dictionnaire-dico","type-dictionnaire-dico","status-publish","hentry","categories-glossary-data-analytics-marketing-intelligence"],"_links":{"self":[{"href":"https:\/\/digitionary.com\/en\/wp-json\/wp\/v2\/dictionnaire-dico\/163522","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/digitionary.com\/en\/wp-json\/wp\/v2\/dictionnaire-dico"}],"about":[{"href":"https:\/\/digitionary.com\/en\/wp-json\/wp\/v2\/types\/dictionnaire-dico"}],"wp:attachment":[{"href":"https:\/\/digitionary.com\/en\/wp-json\/wp\/v2\/media?parent=163522"}],"wp:term":[{"taxonomy":"categories-glossary","embeddable":true,"href":"https:\/\/digitionary.com\/en\/wp-json\/wp\/v2\/categories-glossary?post=163522"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}