On Wednesday 03 March 2004 09:57 am, Ilja Booij wrote: > The solution I can think of now is the following: > > make sure all aliases (or at least their domain part) go into the > database in lowercase. Whenever we check a domain alias, we first > convert the domain string to lowercase. We can then feed it to a query > without using lower(). > > I do see a problem with this though: What if somebody uses another tool > to insert aliases into the database? Then a non-lowercase domain can > slip in, which will not be found in a case-sensitive search.
This is why database level constraints are so important. I know postgresql could enforce this, can mysql?
