Archives of the TeradataForum
Message Posted: Tue, 27 May 2008 @ 14:55:11 GMT
| Subj: || || Re: Exporting non-English character set |
| From: || || Geoffrey Rommel |
| ||While extracting non-English character like ( LATIN CAPITAL LETTER LIGATURE AE, LATIN CAPITAL LETTER ETH ) like from a Oracle table to a
Flat file ( Network attached client )|| |
How is the flat file defined? It is probably UTF-8; in this case the character will appear as a 2- or 3-byte string. LATIN CAPITAL LETTER
LIGATURE AE (U+00C6), for instance, will appear as x'C386'.
| ||or inserting into Teradata table using TPT script|| |
If the flat file is UTF-8, you will have to tell TPT that the input is UTF-8, however that is done.
| ||But by creating a table with a column of LATIN NOT CASESPECIFIC character set, it is possible insert and retrieve these characters
(LATIN CAPITAL LETTER LIGATURE AE, LATIN CAPITAL LETTER ETH)|| |
Yes, because these characters happen to be in the Teradata Latin character set. If you go outside that range -- if you want to store Polish or
Greek or Chinese, for instance -- you will need to define the target column as Unicode.