Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

What does Collation="A" mean in MySQL Indexes?

In phpMyAdmin I have created a Unique index on a column, in the bottom of the screen I have the following:

Indexes:
Keyname = "[Name of column]"
Type = "BTREE"
Unique = "Yes"
Packed = "No"
Column = "[Name of column]"
Cardinality = "7"
Collation = "A"
Null = ""
Comment = ""

What the heck does collation "A" means? ANSI? ASCII? My column is in utf8_unicode_ci, will it still be guaranteed to be unique even with utf8 characters?

like image 230
DaveSthlm Avatar asked Nov 04 '22 04:11

DaveSthlm


1 Answers

https://dev.mysql.com/doc/refman/5.7/en/show-index.html

How the column is sorted in the index. This can have values A (ascending) or NULL (not sorted).

like image 169
Inna Tichman Avatar answered Nov 08 '22 15:11

Inna Tichman