Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 21 Nov 2006 @ 18:35:20 GMT


     
  <Prev Next>   <<First <Prev
Next>
Last>>
 


Subj:   Re: UTF-8, Fastload and linux
 
From:   Victor Sokovin

  As they started this discussion many years ago they are way ahead in providing solutions for this philosophical problem of loading fixed- position variable-byte data. Oracle make clear distinction in their data type definitions regarding the fixed number of bytes or characters, and they support a wide range of char sets, including UTF-8. If I have time, I'll try to load fixed-position UTF-8 data into an Oracle table to see what happens.  


I did a quick test and I seem to be able to load UTF-8 data in fixed-position format using SQL*Loader. I did have to pad the fields with blanks to the maximum value in bytes for each field because the SQL*Loader POSITION parameter still seems to be using the BYTE semantics even if the rest of the control file uses the CHAR semantics. This is a bit disappointing as it implies an extra effort on the extracting side and increases the size of the data file but if it helps improve performance ... Anyway, this is how it seems to be in 9.2 (after a quick test). Perhaps things are easier in 10g?


Regards,

Victor



     
  <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