title: Teradata adding Â in front of special characters
body: <p>I am having an issue where when fast loading data into Teradata Table is causing Â to appear in front of special characters when loading from .csv file.</p>
  
  <p><strong>CSV File</strong></p>
  
  <p>1|Hello, £5.00 has been debited from your account, thank you for your payment.|XXXX|XX|XXXX-XXX-XXX</p>
  
  <p><strong>Teradata Table</strong></p>
  
  <p>1|Hello, Â£5.00 has been debited from your account, thank you for your payment.|XXXX|XX|XXXX-XXX-XXX</p>
  
  <p><strong>Table Definition</strong></p>
  
  <pre><code>CREATE MULTISET TABLE DATABASE1.TABLE1 ,NO FALLBACK ,
   NO BEFORE JOURNAL,
   NO AFTER JOURNAL,
   CHECKSUM = DEFAULT,
   DEFAULT MERGEBLOCKRATIO
   (
    FIELD1 VARCHAR(25) CHARACTER SET LATIN NOT CASESPECIFIC,
    FIELD2 VARCHAR(750) CHARACTER SET LATIN NOT CASESPECIFIC,
    FIELD3 VARCHAR(35) CHARACTER SET LATIN NOT CASESPECIFIC,
    FIELD4 VARCHAR(35) CHARACTER SET LATIN NOT CASESPECIFIC,
    FIELD5 VARCHAR(50) CHARACTER SET LATIN NOT CASESPECIFIC
   ) PRIMARY INDEX ( FIELD1 );
  </code></pre>
  
  <p><strong>Fastload Code</strong></p>
  
  <pre><code>fastload &lt;&lt;-EOF
      .LOGON username/pass;
      DATABASE DATABASE1;
  
          SET RECORD VARTEXT "|";
  
          BEGIN LOADING TABLE1
              ERRORFILES TABLE1_ERR1,
                         TABLE1_ERR2;
  
          DEFINE
              FIELD1      (VARCHAR(25))
              FIELD2      (VARCHAR(750))
              FIELD3      (VARCHAR(35))
              FIELD4      (VARCHAR(35))
              FIELD5      (VARCHAR(50))
  
  
          FILE=${LOAD_FILE};
  
          SHOW;
  
          INSERT INTO DATABASE1.TABLE1
          (
              FIELD1 ,
              FIELD2 ,
              FIELD3 ,
              FIELD4 ,
              FIELD5 
  
          )
          VALUES
          (
              :FIELD1 ,
              :FIELD2 ,
              :FIELD3 ,
              :FIELD4 ,
              :FIELD5 
          );
  
      .END LOADING;
      .LOGOFF;
      .QUIT;
  EOF
  </code></pre>
  
  <p>Does anyone know how to solve this, I am running this from Solaris 10 Fastload Utility v12.00.00.011</p>