I am getting several erros related to data collation and encoding, with MySQL tables in the live running project. I need to work with latinamerican spanish, and I started using (in MySQL tables, verified through Navicat) Character Set: UTF-8 Unicode and Collation: utf8_general_ci. But then, when I upload CVS text data into my tables, a lot of strange signs started to show, when specific spanish characters appeared, like ñ or vocals with a tilde (áéíóú).. Then I changed the varchar and text fields to Collation: utf8_spanish_ci holding Unicode to utf8 Unicode. But in the AppGini default parameters, in the "default character encoding" I selected at first, "US/Ascii Western", but then I changed to "4-byte Unicode UTF-8" but I keep getting encode and collation errors, like when using a search field, I got this error message "Illegal mix of collations (utf8_bin,NONE) and (utf8_general_ci,COERCIBLE) for operation 'like'"...
Any help from Anybody using spanish latinamerica data projects ?
If somebody already solved this issue.. just tell me what you used in the AppGini default parameters, the "Default character Encoding", and then what are you using in the MySQL tables for text fields, the encoding and collation parameters... I will really appreciate that.