Doubt with Collate in SQL statement

I have a question with this statement when creating a table:

  'uid' varchar(100) COLLATE utf8_unicode_ci NOT NULL,

I am used to working with classes int auto_increment. I have read the documentation but I am not entirely clear about the usefulness of this.

Someone can clarify this please.

Greetings, Mal