Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 29 Oct 2004 @ 08:30:23 GMT


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


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

<-- Anonymously Posted: Thursday, October 28, 2004 20:38 -->

I am uncertain about loading from a UTF-8 flat file, but you can load from a regular Unicode (UTF-16) flat file.

If you want to do this, open the UTF-8 data file in notepad and save it with Encoding = Unicode. Then, create a regular ANSI text file named "schema.ini" in the same directory as where you saved the Unicode data file. This file must be named "schema.ini" and must be in the same directory as your data file. The schema.ini file should contain something similar to:

     [filename.txt]
     ColNameHeader=True
     Format=Delimited(|)
     MaxScanRows=25
     CharacterSet=Unicode

In this, filename.txt is the name of your Unicode data file. Yours might be a little different than this depending upon the format of your data file. The important part is the CharacterSet=Unicode line which tells the Microsoft Text Driver that the file contains Unicode. Search the Microsoft website for more information on schema.ini files. Then try the transfer again, just like you did before: use the Microsoft OLE DB Provider for ODBC Drivers and the Microsoft Text Driver to read the Unicode data file.

This works for us and thus I am hopeful that it may work for you.



     
  <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