One quick and dirty method that I have used before is to copy all the data that you are updating from to a temporary table that has the correct collation that you need. Then do your update from the Temporary table.
I would have thought there was a better method than this though, it's fine if it is only one or two places, but it could be a big overhead if it occurs lots of times.