Archives of the TeradataForum
Message Posted: Wed, 09 Nov 2005 @ 20:12:51 GMT
Subj: | | Re: View column data type |
|
From: | | Dempsey, Mike |
When the length is double the format size that implies Unicode data.
It would appear that the Case statement is returning Unicode but the Coalesce is returning ANSI. (If you intended to say 'Column2b' in the
second case.)
Just as a performance note, it would be much faster to issue
help column ..*
than a separate 'help' statements for each column.
Mike Dempsey
Teradata Client Tools
|