To prevent duplicated name & best practice
Posted on 2014-08-18
1- Let say we don't want user to add duplicated company name in the system.
Using a search form, what will be the best practice to use for searching, How far should we go.
(the admin can set to make name and-or phone number verified before to add a new company)
What it does for now, if the system find an "Exact Match", it's prevent to add the company.
Right now if we search : "MyCompanyName"
this will not find "MyCompanyName Inc" exist
and will allow the user to add the company
When searching should the system ignore:
accent (in french we have éàî )
Special caracters like - space & _ . ,
2- Another case when doing a "Regular Search" the system ask a minimum of 4 characters and "space" are considered as 1 characters to my opinion the space should not be counted
The system allow to search "My C"
What will be the best way to manage it?
My Co = 4 not 5
I know we cannot control everything but I'm looking for a moderate way to prevent duplicate company name