title: User Defined Data Types with COLLATION
body: <p>I am trying to find a way of specifying a <code>COLLATION</code> for a user-defined data type, but it doesn't appear to support collations in SQL Server, and it basically takes the collation from the database.</p>
  
  <p>Is there any way of applying a collation against a user defined data type that doesn't inherit from the database collation?</p>
  
  <p>I am writing a database comparison tool, using the <code>AdventureWorks2012</code> database for testing, and after generate an SQL diff script and running it on a blank database the tool is now reporting a lot of differences due to the collation being different to what was actually expected.</p>
  
  <p>I could create the blank database with the same collation as the source database, but I need to consider situations where organisations, etc. may wish to change the collation on the database and my tool will not work consistently and will keep on reporting differences.</p>
  
  <p>Thanks.</p>