 |
 |
Archives of the TeradataForum
Message Posted: Wed, 28 Apr 2004 @ 09:11:43 GMT
| Subj: | | Re: Column Compress Question |
| |
| From: | | Dieter Noeth |
Chris Craig wrote
| | One other thing to be aware of. If you have CASESPECIFIC specified on the column, then you must specify your charater string with the same
mix of upper and lower characters. | |
| | So, to compress 'ABCdef' you should specify | |
| | If NOT CASESPECIFIC then any combination works. | |
No, you still have to specify the right mixture of uppercase/lowercase characters, because otherwise any combination would be stored as
'ABCdef'. A DBMS is supposed to store the string you submitted and not a different one
;-)
Dieter
| |
