samot-dwarf (1/14/2016)
I doubt, that your real solution (specifying an explicit collation string at each char field) is really a real solution, because it is very error prone - you have to find EVERY code line with #temp tables
It's what we do, and very rarely have problems. It's just one more thing we need to remember when coding, and if we forget it's almost always picked up (by code reviews or QA) before it hits production.