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