Re: Unique Constraint Using My Own Definition of "Equals"

[B C]

Rick - thank you very much for the reply. That is a great idea. But since only one script in my entire application needs to select on this column, there's not much benefit in making a comparator function just for that purpose. It's also not critical that I save the user input representation of the data - so an extra column would be unnecessary overhead.

The big issue was getting the DBMS to enforce the funny constraint. I typically like to make sure the database, not the application, is responsible for maintaining the integrity of my data. That way, if myself or one of the other developers write a buggy PHP script, we can't introduce inconsistencies into our database. (Its entirely possible that one of us could forget to "clean up" the input before inserting it.)

But at the moment, it looks like I'm SOL. I'll just have to be careful about inspecting myinsert queries closely.