title: Copy special character in AWS Redshift
body: <p>I'm unable to load special character row in AWS Redshift.</p>
  
  <p>Getting an error: String contains invalid or unsupported UTF8 codepoints. Bad UTF8 hex sequence: c8 4d (error 4)</p>
  
  <p>The string causing the problem is: Crème (the è).</p>
  
  <p>For a temporary fix, I am using:</p>
  
  <pre><code>copy dev.table (a,
  b,
  c,
  d) from 's3://test-bucket/redshift_data_source/test_data.csv'
  CREDENTIALS 'aws_access_key_id=xxxxxxxxxx;aws_secret_access_key=xxxxxxxxxxxx' CSV delimiter ',' IGNOREHEADER 1 COMPUPDATE OFF acceptinvchars;
  </code></pre>
  
  <p><strong>acceptinvchars</strong> is accepting them as varchar but putting ? on those characters. How to read them as is?</p>