title: Is there a windows unicode-only collation?
body: <p>I am trying to get my head around Unicode and Collations and how to use collations properly in ms sql server 2014.<br>
  <a href="https://msdn.microsoft.com/en-gb/library/ms175835(v=sql.120).aspx%20" rel="nofollow">Microsoft</a> states: </p>
  
  <p>"Windows Unicode-only collations can only be used with the <code>COLLATE</code> clause to apply collations to the <code>nchar, nvarchar, and ntext</code> data types on column level and expression-level data. They cannot be used with the <code>COLLATE</code> clause to change the collation of a database or server instance."</p>
  
  <p>What Windows unicode-only collations are? I want to convert my database to support unicode so now  I use only nvarchar, nchar and ntext. I did <code>SELECT * FROM sys.fn_helpcollations()</code> and I got a list of collations. None of them is described as Unicode-only collation.  That's where I am getting confused, if there is a unicode only collation as microsoft states how can I find it and what's the logic behind it? </p>