Comments - LOWER
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.
LOWER, CONVERT and UPPER doesn’t work with accent. I want to convert « é » in « É ».
This page doesn’t explain why upper « Un écho » result in null.
It’s a big problem.
Works with default settings:
SELECT LOWER('Un écho'), UPPER('Un écho'); +-------------------+-------------------+ | LOWER('Un écho') | UPPER('Un écho') | +-------------------+-------------------+ | un écho | UN ÉCHO | +-------------------+-------------------+Ok I think I am not at the good place because I am working with Column Store engine here.
il faut modifier la configuration : https://jira.mariadb.org/browse/MCOL-1211