title: How can I find any non ASCII characters in Redshift database
body: <p>I've a database table I'd like to return all values where a column contains a non ASCII character anywhere in the string.</p>
  
  <p>Is there an easy way to do this?</p>
  
  <p>I've tried this</p>
  
  <pre><code>select col_name,  regexp_instr(col_name,'[^[:ascii:]]') 
  from test_table s
  where created &gt; sysdate - 1 
  and regexp_instr(col_name,'[^[:ascii:]]') &gt; 0 
  limit 5;
  </code></pre>
  
  <p>but get this error:</p>
  
  <pre><code>error:  Invalid character class name, collating name, or character range.  The error occured while parsing the regular expression: '[^[:&gt;&gt;&gt;HERE&gt;&gt;&gt;ascii:]]'.
    code:      8002
    context:   T_regexp_init
    query:     5059536
    location:  funcs_expr.cpp:130
    process:   query20_31 [pid=7903]
  </code></pre>
  
  <p>Thanks!</p>