Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 03 Mar 2004 @ 19:23:20 GMT


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


Subj:   Re: How to import utf8 data from teradata to excel 2002(XP)
 
From:   Shealy, Shawn

Hi Vivek,

You wrote:

  Same column when imported in excel using OLEDB shows junk characters.  


  In excel I am using Data->Import External Data to select the rows from Teradata unicode table.  


  I believe this problem is occurring because Excel works in utf16 charset whereas Teradata in utf8 charset.  


It sounds like you might be trying to use Microsoft Excel to import from Teradata using the ODBC Driver for Teradata. When you do this, keep in mind that the data is converted to the session character set encoding by the Teradata RDBMS.


  Is there anyway to export utf8 data to excel?  


You can use FastExport with the Teradata OLE DB Access Module to output to an Excel file. Be sure to use the UTF8 session character set encoding. FastExport will give the data to the Teradata OLE DB Access Module encoded in UTF8 which will internally convert the data to UTF16 before passing it to the OLE DB provider which ends up outputting the data to the Microsoft Excel file. This way your Unicode strings will be properly preserved. You must use version 2.2.1.1 of the Teradata OLE DB Access Module (available from the GSC patch server) to have UTF8 support. Additional details on this are available at

www.teradataforum.com/attachments/a040130a.rtf


If you pursue this route, you don't even have to compose the FastExport script as the OleLoad tool included in the product does that for you (of course you are free to modify the generated script or even use your own if you prefer).


-shawn :-)



     
  <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