Archives of the TeradataForum

Message Posted: Wed, 14 Sep 2005 @ 20:52:10 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

     Windows   '0D0A'xc   Char(2)
     Unix      '0A'xc     Char(1)
     Mainframe '0D'xc     Char(1)

Some apps on Windows will add the '0D' part automatically if they find text strings containing '0A'.

That means that if you store it with just '0A' it will work on both Unix and in those apps. Other apps will not however.

How it will look when you retreive it depends on the tool you are using. For example, if you use SQL Assistant and export the data, the line feeds will be retained (which probably makes the file rather unreadable) but if you retreive the string into an answerset, the string will be displayed in a cell WITHOUT the line feed... but it is simply hidden in the display - if you copy/paste it into notepad for example (or into the query window) the line feed will reappear.

Teradata used to strip out '0A' and just store the '0D' - probably because '0D' is the string required on IBM mainframes... which is where most data originally came from on Teradata systems.

(It may still do that ... anyone know? Or it may get handled differently in the PE [or gateway] since that knows what kind of system it is talking to.[Mainframe vs network])

So the bottom line is ... It depends...

Mike Dempsey
Teradata Client Tools

	<Prev	Next>		<<First	<Prev	Next>	Last>>