'Change the collation of a sql view
I currently have a view I have created in SQL, It looks at another database, and the view is then used in another process. The problem is that the 2 different databases have a collation conflict, one is CI_AS and the other CP1_CI_AS.
I've looked over the web and seem to find solutions to change the collation on the joins when I link the view to another database, but I can't do that as its an internal process within the product, all it allows me to do is give it a view.
Is there a way I can change the views collation?
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|