Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Wed, 01 Nov 2006 @ 14:49:18 GMT

  <Prev Next>  
Next> Last>>  

Subj:   UTF-8, Fastload and linux
From:   David Clough

Hi all,

We're having problems in loading UTF-8 data which has been exported from Oracle (taken from a Linux server), ftp'd across to a Linux application server and then attempted to Fastload into a table (defined with Unicode columns).

The separator we've been using is the Logical Not '?' but, having read the manual, we now believe we have to use a single byte character, not double byte (as the '?' is seen to be in Linux).

However, we've got all sorts of characters coming through from certain input free-format text fields, so the choice of separator is somewhat limited.

We'd rather not have to convert the process to fixed position data, so I was wondering what you guys either do or would recommend.

Sadly, what Fastload does not have - which Oracle's SqlLoader does have - is the option of defining input fields as Optionally Enclosed by " ", which would have made it all very nice.

What we infer from our experience and what we read is that, whilst Fastload can certainly accommodate UTF-8 data, it cannot use anything other than standard single byte delimiters.

Anyone know how to get out of this conundrum ?


Dave Clough
Database Designer
Express ICS


  <Prev Next>  
Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020