MySQL Forums
Forum List  »  Newbie

Re: making a unique registry account number using 2 entries
Posted by: Peter Brawley
Date: February 16, 2015 10:50AM

> When someone registers I want them to enter their date of birth then add last 4 digits of SIN#

You say SIN, which is what the number is called in Canada, which severely restricts private use of SINs. If you meant the US SSN, it's still a terrible idea to use the SSN as an ID, some states are already restricting such use, and more soon will.

And DOB can have dupes.

Better solution: have the user pick a user name on which you enforce uniqueness.

Options: ReplyQuote


Subject
Written By
Posted
Re: making a unique registry account number using 2 entries
February 16, 2015 10:50AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.