All Forums Database
tmcrouse 29 posts Joined 07/14
14 Jul 2014
New to Teradata Help with data type

I found a document on this site that shows various data types, however I do not see phone or email related data types. Can anyone point me to how I set up this type of datatype?

dnoeth 4628 posts Joined 11/04
15 Jul 2014

A phone or email is simply a VarChar with some added validation rules.
Which DBMS has built in dataypes like that?

Dieter

tmcrouse 29 posts Joined 07/14
15 Jul 2014

Access lets you do text and then you have to format it but was not sure if teradata was different. So, I will Google validation rules to see how to set up validation.

Raja_KT 1246 posts Joined 07/09
15 Jul 2014

If you check the phone formats of each country, you will see some formats and some countries have quite a number :) . I don't think any DBMS will resort to using phone as a datatype.

Raja K Thaw
My wiki: http://en.wikipedia.org/wiki/User:Kt_raj1
Street Children suffer not by their fault. We can help them if we want.

You must sign in to leave a comment.