[Wikitech-l] Re: ListFiles special page

2021-10-15 Thread Jaime Crespo
s/they/emojis/ On Fri, Oct 15, 2021 at 2:12 PM Jaime Crespo wrote: > I don't want to defend MySQL development decisions- in fact PHP made some > similarly bad ones, but it would be unfair to judge them too harsly with > the "power of hindsight" [0]- but... /pedantic on > > On Thu, Oct 14, 2021

[Wikitech-l] Re: ListFiles special page

2021-10-15 Thread Jaime Crespo
I don't want to defend MySQL development decisions- in fact PHP made some similarly bad ones, but it would be unfair to judge them too harsly with the "power of hindsight" [0]- but... /pedantic on On Thu, Oct 14, 2021 at 7:37 PM Roy Smith wrote: > What part of "universal" did they not

[Wikitech-l] Re: ListFiles special page

2021-10-14 Thread Roy Smith
It's years since I discovered that mysql's utf8 is broken in this way, but I can still feel the pain. What part of "universal" did they not understand? The mysql docs more or less say that "utf8" is deprecated, certainly not future-proof, and suggest you use utf8mb4. See

[Wikitech-l] Re: ListFiles special page

2021-10-14 Thread Sergey Dorofeev
Thank you, did not know about it. Real UTF-8 in mysql is utf8mb4, I think it should be used here. --- Sergey Jaime Crespo писал 2021-10-14 18:32: I agree that LOWER doesn't make much sense in binary collation. Sadly, a utf8 (3-byte UTF-8) conversion may fail for 4-byte characters, so at

[Wikitech-l] Re: ListFiles special page

2021-10-14 Thread Jaime Crespo
I agree that LOWER doesn't make much sense in binary collation. Sadly, a utf8 (3-byte UTF-8) conversion may fail for 4-byte characters, so at the very least it should be utf8mb4 (4-byte UTF-8). I am not so familiar with ListPager to say if there could be other issues arising from that- sending a

[Wikitech-l] Re: ListFiles special page

2021-10-14 Thread Andre Klapper
Hi Sergey, On Thu, 2021-10-14 at 18:16 +0300, Sergey Dorofeev wrote: > I have got issue with ListFiles page in mediawiki 1.35.1 > text in middle of file name. > I looked in DB and saw that img_name column is varbinary, but > pagers/ImageListPager.php tries to do case-insensitive select with >