Access 2021 : "like" clause with SQL don't work with accent
Hello, I'm using MS Access 2021 with an Access version 2021 database. I noticed that if I use the "like" clause with a text field containing accented text AND if the field is indexed (with or without duplicates), my SQL query returns no data. The only solution I found so far, is to remove the indexing property on my field. Does anyone have another solution please? Thanks in advance.