alphabetical order is case sensitive

CMU-CREATE-Lab / preK-emotions-app

Other

1 stars 2 forks source link

alphabetical order is case sensitive #120

Closed ehamner closed 2 years ago

ehamner commented 2 years ago

On kindle and A7

Students are alphabetized Capital letters, then lower case letters. I would have expected capitalization to be ignored.

Example: Cat apple gerbil

tasota commented 2 years ago

I was playing around with ways to make the default column info ignore case (sqlite keywords COLLATE NOCASE) but it was not behaving as I expected, so instead I just added the lower() function in the SQL calls for students and classrooms.