View Issue Details

Category
整備班:YAYA
SeverityminorReproducibilityalways 
Status closed 
Summary0000431: non-standard english characters are unaffected by TOLOWER and TOUPPER
DescriptionTrying to use tolower on a string that contains letters that are not standard in the english alphabet (such as those present in icelandic, for example) only returns the uppercase version of those letters, instead of the lowercase version. The cyrillic and greek alphabets have the same issue, but to a more noticeable degree, as none of the letters are shared with the latin alphabet, as far as computers are concerned. (toupper has the same kind of result but it's not the one I'm using in my code)
I'm not sure if it has something to do with the charset. I've told it at every opportunity to use UTF-8 -- so maybe that's affecting it somehow?
I've attached a picture to maybe show what i mean better - none of them are actual words as I know neither icelandic nor greek.

yaya is Tc-569-4, although it's been a problem since at least tc-548-1 (and possibly even before then)
TagsNo tags attached.
Attach Tags
Attached Files
image.png (67,031 bytes)   
image.png (67,031 bytes)   

Activities

ponapalt

2022-02-12 22:36

administrator   ~0001107

Tc569-5
https://github.com/ponapalt/yaya-shiori/releases

Please add second parameter to TOLOWER / TOUPPER such as this :

TOLOWER("texttext","ja-JP")

default locale is "C", which just converts A-Z to a-z. (normal alphabet only)

Issue History

Date Modified Username Field Change
2022-02-12 05:41 guest New Issue
2022-02-12 05:41 guest File Added: image.png
2022-02-12 22:36 ponapalt Assigned To => ponapalt
2022-02-12 22:36 ponapalt Status new => closed
2022-02-12 22:36 ponapalt Resolution open => fixed
2022-02-12 22:36 ponapalt Note Added: 0001107