title: Setting collation property in the connection string to SQL Server 2005
body: <p>I have a ASP.Net web application with connection string for SQL Server 2005 in the web.config.</p>
  
  <pre><code>    Data Source=ABCSERVER;Network Library=DBMSSOCN;Initial Catalog=myDataBase;
  User ID=myUsername;Password=myPassword;
  </code></pre>
  
  <p>I want to specify the collation property in the web.config for different languages like French like</p>
  
  <pre><code>    Data Source=ABCSERVER;Network Library=DBMSSOCN;Initial Catalog=myDataBase;
  User ID=myUsername;Password=myPassword;Collation=French_CS_AS
  </code></pre>
  
  <p>But the <strong><em>Collation</em></strong> word is not valid in the connection string.</p>
  
  <p>What is the correct keyword that we need to use to specify the collation in SQL Server 2005 connection string?</p>
  
  <h1>Edit</h1>
  
  <p>I understand that collation can be set during the database installation and can also be changed. I do not want to change it permanently in the database. But I want the SQLClient to set the collation based on the application's settings.
  I only want use it when using SQL Query like </p>
  
  <pre><code>SELECT * FROM TESTTABLE ORDER BY TESTCOLUMN COLLATE French_CS_AS
  </code></pre>
  
  <p>I am trying to ensure that for a given connection, all the commands/queries for that connection would automatically use the <code>"French_CS_AS"</code> - based on the property setting in the connection string, rather than changing the query definitions</p>