Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Mon, 17 Mar 2003 @ 21:59:03 GMT


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


Subj:   Re: Case sensitivity in duplicate value checking against character datatypes question
 
From:   Dwight Etheridge

Fastload or bteq, your second row will bounce unless you specify 'cs' (case specificity) on COL1. I built the following script, just to check myself.

database equitree;

drop table eds_cs;
ct eds_cs (

 COL1 CHAR(3)  NOT NULL
,COL2 SMALLINT NOT NULL
,COL3 VARCHAR(80) NULL )
unique primary index (COL1,COL2)

ins eds_cs values('AAA',     100    , 'sample data row 1 ');
ins eds_cs values('aaa',     100   ,  'sample data row 2 ');  <-- fails

/* the following works fine */

drop table eds_cs;
ct eds_cs (

 COL1 CHAR(3) cs NOT NULL
,COL2 SMALLINT NOT NULL
,COL3 VARCHAR(80) NULL )
unique primary index (COL1,COL2)

ins eds_cs values('AAA',     100    , 'sample data row 1 ');
ins eds_cs values('aaa',     100   ,  'sample data row 2 '); <-- wont
fail

--
Dwight Etheridge
Teradata Certified Master



     
  <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: 27 Dec 2016