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 Join Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky 
Last Modified: 30 Jun 2008