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>>