We recently decided to change from the default collation of UTF8_BINARY to UTF8_LCASE and there are many issues.  We attempted to cascade the collation defaults to all the Catalogs, Schemas, Tables, Views and Columns, but we still seem to have expression errors or data type mismatch errors.  Anyone has some advice on how to get all our notebooks and views going again with out explicit collation commands ?