Home Page for the TeradataForum
 

Archives of the TeradataForum

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


     
  <Prev Next>  
<<First
<Prev
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 ?


Thanks,

Dave Clough
Database Designer
Express ICS

www.tnt.com



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