Re: Case insensitive search in utf8 db

[John Stergiou]

I really appreciate your efforts to help me but you do not see the whole picture. The db is already created. The table has a column with names (first and last nane in the same column, sometimes first name leads, sometimes follows last name. wrong or right? They just did it.) another column has a title. They asked me to find a way to do search in these columns. They gave me a sample db to do my tests. Forget what I said about equal values. You mentioned to create a table with the triples. I can't make it. I do not have the data to create it. I know that it can be done without the table you mentioned. I have seen it but the developers of the code do not give help as they are afraid of sql injection or virus/Spyware attacks. They only said they succeeded without table like yours.