Topic on Talk:Quarry

LOWER/UPPER function not working on page_title

3
Summary by BDavis (WMF)

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)) .

Saeidpourbabak (talkcontribs)

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

Zhuyifei1999 (talkcontribs)
Saeidpourbabak (talkcontribs)

Thanks for the quick and helpful reply. It works perfectly.