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
|
>Col1=InvAssetType varchar
Col1=InvAssetType char width 5
|
Col1=InvAssetType char width 6
Col2=InvType varchar width 10
|
Col1=InvAssetType char width 6
Col2=InvType varchar width 10
|