title: SQL Server turkish character situation
body: <p>I am having a Turkish Character problem in ASP.NET and SQL Server. I have searchbox in asp.net and trying to do a search in database. However, I am having problems in Turkish characters. When I search for "GALVANİZ" which contains illegal "İ" character. the word "GALVANİZ" is in the database, I am sure.</p>
  
  <p>When I do a simple select statement in SQL Server tool, it doesn't return anything either. </p>
  
  <p>Here is the SQL</p>
  
  <pre><code>select * from Product where name like '%GALVANİZ%'
  </code></pre>
  
  <p>This doesn't return anything. How can I get it fixed?</p>
  
  <p>thanks</p>