title: Postgresql COPY encoding, how to?
body: <p>I am importing a .txt file that contains imdb information(such as moviename, movieid, actors, directors, rating votes etc) I imported it by using the COPY Statement. I am using Ubuntu 64 bit. The problem is, that there are actors having different names, such as Jonas Åkerlund. That is why postgresql throws an error:</p>
  
  <blockquote>
    <p>ERROR:  missing data for column "actors"
     CONTEXT:  COPY movies, line 3060: "tt0283003   Spun    2002    6.8  30801  101 mins.   Jonas Ã"
    ********** Error **********</p>
    
    <p>ERROR: missing data for column "actors"
    SQL state: 22P04
    Context: COPY movies, line 3060: "tt0283003 Spun    2002    6.8 30801   101 mins.   Jonas Ã"</p>
  </blockquote>
  
  <p>My copy statement looks like this:  </p>
  
  <pre><code>COPY movie FROM '/home/max/Schreibtisch/imdb_top100t.txt' (DELIMITER E'\t', FORMAT CSV, NULL '');
  </code></pre>
  
  <p>I do not exactly know, how to use the collation statement. Could you help me please? As always, thank you. </p>