Archives of the TeradataForum

Message Posted: Mon, 16 Feb 2015 @ 20:53:44 GMT

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

Hi Forum,

Is there a syntax to find/list the special characters in Teradata table and any way to restrict input values the time we insert into table.

for example,

     drop table test;
     create table test
        (restrictinputtest VARCHAR(20) CHARACTER SET LATIN NOT CASESPECIFIC);

     insert into test values('06ÇÇ168053735 ÇÇ');
     insert into test values('0616ÇÇ8053735Ç ');

     select * from test;

results:

          restrictinputtest
     1    06ÇÇ168053735 ÇÇ
     2    06168ÇÇ053735 Ç

here is it possible to make the column only accept between(0-9,a-z,A-Z) the time insert statement run, thus rejecting special characters indeed.

Thanks,

Sandeep.

GANGA SANDEEP KUMAR

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