What will collation influence on server and website?

There are example some defined variables like:
1. MySQL connection collation like:
utf8_unicode_ci

2. MySQL code table like:
UTF-8 Unicode (utf8)

3. Rules of sorting like:
utf8_unicode_ci

What will exact influence these 3 points?
I mean in real communication path (server and client PC or browser)?