title: How to identify unicode text in sql?
body: <p>Table1 has nvarchar column called umsg which contains unicode text and some time english also.</p>
  
  <p>I want to find out English text present in umsg column.</p>
  
  <pre><code>select * 
  from table1 
  where 
      RDate &gt;='01/01/2014' and RDate &lt; '09/26/2017' 
      and umsg = convert(varchar(max), umsg)
  </code></pre>
  
  <p>I used above query that work fine in regional language but some time fail.
  Suppose col contain text like 'ref no Ã©tÃ©'
  I think above message is unicode, if I used above query, it/sql is showing me as English not unicode.How to handle this.</p>
  
  <pre><code>Table :
  Id  Date                      Umsg
  1   2017-09-12 00:00:00.000   The livers detoxification processes.
  2   2017-09-11 00:00:00.000   Purposely added 1 
  3   2017-09-10 00:00:00.000   फेंगशुई के छोटे-छोटे टिप्स से आप जीवन की विषमताओं से                       स्वयं को बचा सकते
  4   2017-09-17 00:00:00.000    तनाव एक लाइलाज बीमारी कतई नहीं है। कुछ लोग तनाव को                                     आसानी से झेल लेते ह
  5   2017-09-17 00:00:00.000    ref no Ã©tÃ©
  </code></pre>
  
  <p>Above is data present in my table.
  But I want data/Output like :</p>
  
  <pre><code>    Id      Date                      Umsg
      1   2017-09-12 00:00:00.000   The livers detoxification processes.
      2   2017-09-11 00:00:00.000   Purposely added 1
  </code></pre>