title: Copy NULL in PostgreSQL database
body: <p>I am trying to copy a CSV file into Postgres 9.5.3 and running into issues with NULL. The file is encoded in ASCII, my client_encoding is UTF-8, and server encoding is UTF-8. 
  The null is in a quoted string as shown below.</p>
  
  <p><a href="https://i.stack.imgur.com/hzzgB.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/hzzgB.png" alt="enter image description here"></a></p>
  
  <p>I get this error </p>
  
  <pre><code>ERROR:  invalid byte sequence for encoding "UTF8": 0x00
  CONTEXT:  COPY test_null, line 1
  ********** Error **********
  
  ERROR: invalid byte sequence for encoding "UTF8": 0x00
  SQL state: 22021
  Context: COPY test_null, line 1
  </code></pre>
  
  <p>My table structure is </p>
  
  <pre><code>CREATE TABLE TEST_NULL(NULLCOLUMN CHAR(10));
  
  copy TEST_NULL from 'F:\User Area\DCS.TXT' csv  NULL AS 'null';
  </code></pre>
  
  <p>I have tried escaping it by specifying "\", and tried other options of Copy command, but nothing seems to work. Not sure, how to process this.</p>