Archives of the TeradataForum
Message Posted: Wed, 04 Aug 2004 @ 08:56:03 GMT
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
|