title: Convert nvarchar to varchar in c# to mirror SQL's functionality
body: <p>I'm maintaining a legacy database and one of the tables has a primary key over three columns. Two of the columns are varchar(100)</p>
  
  <p>Sometimes the system tries to insert data such as <code>F1501</code> and <code>Φ1501</code> from our datasource (which is correct). However, SQL it would appear doesn't support these values for a primary key, so it converts <code>Φ</code> to <code>F</code> silently and this creates a primary key conflict.</p>
  
  <p>In my c# application, I want to check for duplicates, so I need a way to compare <code>Φ1501</code> to <code>F1501</code> to generate a match so that I can skip inserting it.</p>
  
  <p>Any ideas?</p>