title: SQL Server Column names case sensitivity
body: <p>The DB I use has French_CI_AS collation (CI should stand for Case-Insensitive) but is case-sensitive anyway. I'm trying to understand why.</p>
  
  <p>The reason I assert this is that bulk inserts with a 'GIVEN' case setup fail, but they succeed with another 'Given' case setup.</p>
  
  <p>For example:</p>
  
  <ul>
  <li><code>INSERT INTO SomeTable([GIVEN],[COLNAME]) VALUES ("value1", "value2")</code> fails, but</li>
  <li><code>INSERT INTO SomeTable([Given],[ColName]) VALUES ("value1", "value2")</code> works.</li>
  </ul>
  
  <p><strong>EDIT</strong>
  Just saw this:</p>
  
  <p><a href="http://msdn.microsoft.com/en-us/library/ms190920.aspx" rel="noreferrer">http://msdn.microsoft.com/en-us/library/ms190920.aspx</a></p>
  
  <p>so that means it should be possible to change a column's collation without emptying all the data and recreating the related table?</p>