On Wednesday 03 March 2004 09:32 am, Ilja Booij wrote: > Just when I was ready to commit the changes, I found out that MySQL > cannot have an index like: > > INDEX (lower(alias)), because it cannot have expressions in an index.. > > So, the whole plan is a no-go. Unless we can come up with some other way > to do the same thing. We could change all strings that we need to check > case insensitively to lowercase before feeding it them to the query > for instance. Are there any convenient functions functions for this > (that also work with characters other than A-Z?
I don't see the problem, or don't understand it. I know the much of the sql now in db.c has to be common between both database servers, but the index creation command is located in the database creation script right? Those scripts are independent are they not? Am I missing something? Thanks, Matthew
