Case insensitive search without additional rules?
Posted by:
Marty -
Date: August 11, 2009 02:03AM
Hello,
I'm trying to find a collation in MySQL (my version is 5.0) where strings that differ in case are considered the same but there're no other rules like:
รก = a
and so on.
I tried to find the proper collation here:
http://www.collation-charts.org/mysql60/by-charset.html but it seems that the collation I'm looking for doesn't exist.
I can't use in SQL query: SELECT ... WHERE lower(column1) = lower(column2) because indices on columns column1 and column2 are not used then and my query is terrible slow.
Thanks for any suggestion!
Subject
Views
Written By
Posted
Case insensitive search without additional rules?
5229
August 11, 2009 02:03AM
2373
August 13, 2009 05:56AM
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.