Accent mysql table

Asked

Viewed 81 times

1

Good morning.

I have a table in the database and I need to make 2 selects in it:

For the first search I’m using this and is returning everything I need: 

SELECT * FROM wp_memoria WHERE memo_de IN ($words)

The second, I need to search case-sensitive and Accent-sensitive, but I can’t make it work at all. A solution I found gave me this result:

SELECT * FROM wp_memoria WHERE CAST(memo_de AS CHAR CHARACTER SET latin1) COLLATE latin1_general_cs_ai IN ($words) AND status = 1

But it doesn’t work when the search has accent in the middle.

Follow the structure of my table:inserir a descrição da imagem aqui

mysql database

  • face has to do with formatting tries to put a utf8_general_ci collate in your query

  • here you can find some useful information https://stackoverflow.com/questions/8647080/accent-insensitive-search-query-in-mysql

  • I tried this: SELECT * FROM wp_memoria WHERE memo_de COLLATE utf8_general_ci IN ($words) AND status = 1. No success yet

No answers

Browser other questions tagged mysql database

You are not signed in. Login or sign up in order to post.