![]() |
|
![]() |
![]() |
Archives of the TeradataForumMessage Posted: Mon, 16 Feb 2015 @ 20:53:44 GMT
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
| ||||||||||||||||||||||||||||||||||||||||||||||
https: | ||||||||||||||||||||||||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||||||||||||||||||||||
![]() | ||||||||||||||||||||||||||||||||||||||||||||||||
Copyright 2016 - All Rights Reserved | ||||||||||||||||||||||||||||||||||||||||||||||||
Last Modified: 24 Jul 2020 | ||||||||||||||||||||||||||||||||||||||||||||||||