Collation precedence is determined after data type conversion. The operand from which the resulting collation is taken can be different from the operand that supplies the data type of the final result ...

[!INCLUDE SQL Server SQL MI] The server collation acts as the default collation for all system databases that are installed with the instance of [!INCLUDEssNoVersion], and also any newly created user ...