Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Wed, 09 Nov 2005 @ 22:12:16 GMT

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

Subj:   Re: View column data type
From:   Mike Felts

Yes I did mean column2b in the last post, sorry about that.

So it looks like CASE returns UNICODE and COALESCE returns ANSI? Is there a way to get CASE to return ANSI as well? It seems to be unexpected by MicroStrategy (and to my common sense) that the "Max Length" that's returned is twice the size that the "Format" would indicate. The only other difference I see between the information returned by a "help column" is that "Char Type" is 2 instead of 1 for the CASEd column.

Any ideas anyone?

Thanks greatly for the help thus far.


  <Prev Next>   <<First <Prev Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020