Re: Case insensitive search in utf8 db
Posted by: Peter Brawley
Date: December 01, 2019 03:08PM

Good, it shows your server and its settings are ok for case detection, so the problem is in the design of the db or table you're having problems with.

So please post the results of ...

use dbname;
show variables like 'character%';
show variables like 'collat%';
Show Create Database dbname;
Show Create Table tblname;

... where dbname and tblname are the respective names of the db and table where you're having the problem.

Options: ReplyQuote

Written By
November 29, 2019 01:14PM
Re: Case insensitive search in utf8 db
December 01, 2019 03:08PM

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.