Geetika Kolli | 2018-03-09 01:38:09.0 | |
| Hi Team,
Issue ? Connecting to FTP , Delimited flat file treat varchar data type as LongVarchar data type Detailed Information ? ? We are connecting to a delimited flat file having one of the field as Varchar datatype. ? while executing select query, it is treating varchar datatype as LongVarchar. As per the requirement, we want varchar datatype to treat as Varchar (should not get converted into any other datatype) Can you please let know how we can prevent the implicit Data type conversion. Thanks, Geetika Kolli | ||
HXTT Support | 2018-03-13 02:23:26.0 | |
| >Col1=InvAssetType varchar
Col1=InvAssetType char width 5 | ||
HXTT Support | 2018-03-13 02:25:08.0 | |
| Col1=InvAssetType char width 6
Col2=InvType varchar width 10 | ||
HXTT Support | 2018-03-13 02:25:18.0 | |
| Col1=InvAssetType char width 6
Col2=InvType varchar width 10 | ||