title: Ignoring accents in SQL Server using LINQ to SQL
body: <p>How can I ignore accents (like ´, `, ~) in queries made to a SQL Server database using LINQ to SQL?</p>
  
  <p><strong>UPDATE:</strong></p>
  
  <p>Still haven't figured out how to do it in LINQ (or even if it's possible) but I managed to change the database to solve this issue.
  Just had to change the collation on the fields I wanted to search on. The collation I had was:</p>
  
  <pre><code>SQL_Latin1_General_CP1_CI_AS
  </code></pre>
  
  <p>The CI stans for "Case Insensitive" and AS for "Accent Sensitive". Just had to change the AS to AI to make it "Accent Insensitive".
  The SQL statement is this:</p>
  
  <pre><code>ALTER TABLE table_name ALTER COLUMN column_name column_type COLLATE collation_type
  </code></pre>