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

> The db is already created.

All new dbs have errors. When found, they need to be corrected.

(For a basic intro on database design see

> 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?

Wrong, breaks atomicity---an elementary normalisation error.

> They asked me to find a way to do search in these columns.

If they don't know normalisation, they've no business designing databases.

> You mentioned to create a table with the triples.

It's a just a wee test/demonstration table for values that are case-insensitively equal but case-sensitively unequal. Its only purpose is to find whether your problem is specific to the db or table you referenced, or in in your server

> I can't make it. I do not have the data to create it.

Eh? Creating it needs no data. Populating it needs just the wee script I posted.

> They only said they succeeded without table like yours.

Meaningless---it's just just a temporary diagnostic device. It's not designed to accept your data.

Again, let's see the result of running my script on your server. Use the mysql client program.

Edited 1 time(s). Last edit at 12/01/2019 02:35PM by Peter Brawley.

Options: ReplyQuote

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

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.