Archives of the TeradataForum
Message Posted: Thu, 28 Oct 2004 @ 19:57:56 GMT
<-- 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.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 23 Jun 2019|