Hi,
Can somebody tell me why lower/upper function works properly on a given string (like 'ABC' or 'abc') but not on page_title?
Thanks
page_title is a binary field rather than a text field so you must cast it to a text format before operating on it as a string: LOWER(CONVERT(page_title USING utf8mb4))
.
Hi,
Can somebody tell me why lower/upper function works properly on a given string (like 'ABC' or 'abc') but not on page_title?
Thanks
The column is binary. You need to decode it with utf8/utf8mb4 first. quarry:query/27769