Archives of the TeradataForum

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

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

<-- 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>>