Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 04 Aug 2004 @ 08:56:03 GMT


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


Subj:   Re: Character set information
 
From:   Victor Sokovin

  How do we get the character set information for each column with out querying dbc.columns?  



DataType in PrepInfo does not contain information about the character set used as is explained in the DataInfo specifications.

There is, however, an extended version PrepInfoX, which provides an additional field DataExtType. The field contains the following codes for character sets:

     Not character data: 0
     Latin1: 1
     Unicode: 2
     KanjiSJIS: 3
     Graphic: 4
     Kanji1: 5

Perhaps you could try this extended parcel and check whether it works for you.


Regards,

Victor



     
  <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: 15 Jun 2023