In this example the staging collation is Latin1_General_CI_AS and the production collation is SQL_Latin1_General_CP1_CI_AS. We will change the staging collation to SQL_Latin1_General_CP1_CI_AS.

From the names of the collations, _CI_ means case incensitive. Initially you were trying to change the collation because case sensitivity is différent.

Is there a typo ? Or this is another example ?