Re: Collation set to latin1_swedish_ci incompatible with latin1_bin

[Donal Lynch]

Hard to tell without the context, but it might be that the WebGUI developers are specifying latin1_bin because they intend assetIds to be case-sensitive (_ci in the default collation is 'case insensitive'), and the server is throwing up its hands because it's being asked to compare assetIds declared as case-insensitive in an old table and assetIds declared as case-sensitive in a new table. What is the collation of the assetId column in the different tables in the query?