Yes  Colation A is correcto for a DB, but columns are in collationB. I don't know how this occurs, but the application have bugs that occurs for the collations.

Yes, the...