Archives of the TeradataForum
Message Posted: Wed, 03 Mar 2004 @ 19:23:20 GMT
| Subj: || || Re: How to import utf8 data from teradata to excel 2002(XP) |
| From: || || Shealy, Shawn |
| ||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 22.214.171.124 of the Teradata OLE DB Access Module (available from the GSC patch server) to have UTF8 support.
Additional details on this are available at
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).