Re: SQL Error 1366 Incorrect string value \xF1a for column

[Peter Brawley]

Your post apparently reproduces your charset issues eg the ? in 'faun�a ' is hex EF BF BD, which is UTF-8 for FFFD, the Unicode replacement character (used for data corruption, when characters cannot be converted to a certain code page).

So, what's the encoding of the input? See "Diagnosing charset issues at http://mysql.rjweb.org/doc.php/charcoll#diagnosing_charset_issues.