Does a collation have any influence over a query speed? Does the size of a table change depending of the collation?
If I want to build a website that must support all possible languages (lets take for e.g. Google) which would be the recommended collation?
I will need to store characters such as
日本語, my searches over the website will have to return
something for the
sóméthíng input, it must be case insensitive as well.
How do I know which is the best choice to make? Which collation better suits this case?