Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Tue, 27 May 2008 @ 14:55:11 GMT

  <Prev Next>   <<First <Prev

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.

  <Prev Next>   <<First <Prev
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020