Archives of the TeradataForum
Message Posted: Wed, 08 Sep 2004 @ 14:38:27 GMT
| Subj: || || Re: Load ASCII using TDAT Utility with HEX input data. |
| From: || || Victor Sokovin |
| ||(By the way, everybody, it is not really correct to say that a field contains "hexadecimal values". Every field contains hexadecimal
values! Hex is just another way of spelling out what is in the bytes.)|| |
Agreed. I for one read such a description as though hex digits are just there in "plain visible text" (let's say ASCII, for example, but
I don't want to confuse anybody further with this terminology), so to speak. Either on file level or in a (VAR)CHAR field in the database.
If that's indeed the case here, it would probably make sense to investigate whether that was the intention of the data supplier or the file
just went through some unwanted character conversion. Geoffrey already mentioned FTP...