Ok, well you can try to set your database collation to “latin1_swedish_ci” instead of “utf8_spanish_ci”, and of course use the same collation un your database configuration file, like this:
$db[‘default’][‘char_set’] = “latin1”;
$db[‘default’][‘dbcollat’] = “latin1_swedish_ci”;
As you correctly did.
Or you can try utf8, but be careful to use “utf8_unicode_ci” instead of the “utf8_general_ci” that you are currently using, and you should change your config accordingly to this:
$db[‘default’][‘char_set’] = “utf8”;
$db[‘default’][‘dbcollat’] = “utf8_unicode_ci”;
Please note that the $db[‘default’][‘char_set’] value doesn’t have a hyphen (this is wrong: “utf-8”).
Try the first option or the second, both should work without any trouble, but please tell us about any further problems you might face.
Regards!
