First some definitions:
Character set: List of characters with their identification code.
Collations: Set of rules to compare characters in a given character set.
utf8_spanish_ci : Modern Spanish
utf8_spanish2_ci : Traditional Spanish.
In both collations : 'ñ' is an independent letter, between 'n' and 'o'.
Traditional Spanish : 'ch' is a letter, sorted between 'c' and d, and 'll' is a letter that is placed between 'l' and 'm'
It means that if you use the utf8_spanish2_ci there will be two more letters and that both will allow you to have the letter eñe (Ñ) inside your data and to show them.
NO they have nothing to do with the amount of data that will be inserted, they only define which letters will be displayed and which will not, that is, if you use spanish_ci, the EÑE (Ñ) something like "ÑAME" will be shown in the data, otherwise another type of collation would show you:
Ã¡Ã³Ã± instead of EÑE (Ñ) and other elements such as accents and words agreed and also you would appear the Character inspector where is the EÑE (Ñ)
Stop by here to see the problems it would generate:
Why the Inspector character ( ) appears in some data obtained from the Database?
I recommend utf_spanish_ci and then encode your HTML documents in utf-8, just like I did in my problem
When creating the MySQL database, make sure that the string and other fields are in utf8_spanish_ci and the collation of the tables as well.
Some pages I recommend only utf8_spanish_ci for string and the rest
in utf8_unicode_ci, but I do not know how good it is, because I have not
<head> of all HTML files:
<meta http-equiv="Content-type" content="text/html; charset=utf-8" />
mysql_query("SET NAMES 'utf8'");