Bug #15940 new data types
Submitted: 22 Dec 2005 19:23
Reporter: d d Email Updates:
Status: Open Impact on me:
Category:MySQL Server Severity:S4 (Feature request)
Version: OS:
Assigned to: CPU Architecture:Any
Triage: D5 (Feature request)

[22 Dec 2005 19:23] d d
I am interested in some new data types that I often work with:

email -    user @ domain.com
urls (like http, ftp, etc)
phone #'s

why are they needed?

an example: user@email.com.... it would support a validator to make sure the email address is the right format, and it would be searchable on the domain.com index

a url index would also be searchable on domain names, hopefully indexed in reverse order (.com, cnn.com, sub.cnn.com). 

I find myself programming these data types over and over again for different applications

How to repeat:
[1 Mar 2014 11:55] Daniƫl van Eeden
Datatypes for IPv4 and IPv6 adresses would be nice.