Re: Case insensitive search in utf8 db
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.
Subject
Views
Written By
Posted
2116
November 29, 2019 01:14PM
967
November 29, 2019 04:31PM
908
November 30, 2019 02:04AM
799
November 30, 2019 10:37AM
817
November 30, 2019 03:46PM
831
November 30, 2019 05:32PM
Re: Case insensitive search in utf8 db
816
December 01, 2019 02:13AM
676
December 01, 2019 02:00PM
656
December 01, 2019 02:47PM
811
December 01, 2019 03:08PM
843
December 02, 2019 11:34AM
661
December 02, 2019 12:51PM
695
December 02, 2019 01:20PM
691
December 02, 2019 01:40PM
707
December 02, 2019 02:47PM
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.