Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 28 Oct 2004 @ 19:57:56 GMT


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


Subj:   Help to Transform UTF8 data file to Teradata using OLE DB AXMOD
 
From:   Anomy Anom

<-- Anonymously Posted: Thursday, October 28, 2004 15:47 -->

I have data file, That contains UTF8 characters(Multi languade Characaters, say this data file has characters of English, japanese, Latin, Chinese, Russion and Etc.. and the data file is stored as UTF8 format, Now my task is to load the UTF8 data file to teradata and the same thing to be done using NCR OLE DB AXSMOD. For the same i created a dsn say test1 for data file using Microsoft Text Driver.

To transform the UTF8 data files to Teradata, loaded oleload, selected Microsoft OLE DB Provider for ODBC Drivers and selected data file dsn test1 and set session character set=UTF8 in extented property(This both done using data link), clicked OK, data file was listed in table, and target is selected as NCR Teradata("Teredata"), once source and target connection is set, selected Tpump and launcehed Tpump, data transformation went OK to Target, But UTF8 Characters were not tranformed correctly,

My question, Is my approach is correct to do the same? and also looking help to do the same. in advance i appreciate all.



     
  <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: 27 Dec 2016