LoginLogin
Nintendo shutting down 3DS + Wii U online services, see our post

Case Sensitive Logins..

Root / Site Discussion / [.]

SwordxCreated:
Can we make it so logins are no longer case sensitive? I couldn't log in for the past few days because I didn't realize that our username for our login is case sensitive, and I know I can't be the only one who has had this issue.

Sorry to thread-jack, but I'm, uh, pretty sure I never posted here: Are you guys using post time as a key somewhere? Naughty.

Well, some people want case sensitive logins, others don't. IDK, I think case sensitive is the way to go, because the usernames ARE case sensitive. As for that bug, I'll look into it. Next time, post it on the bug thread so that I can see it for myself. Now that you posted here, it's going to be REALLY hard to figure out what's going on.

Sorry, I wasn't thinking much :/ As for the usernames, I think case-sensitive is pointless but don't mind it at all, but there has to be a warning or notice about it after a failed login attempt.

Sorry to thread-jack, but I'm, uh, pretty sure I never posted here: <snip> Are you guys using post time as a key somewhere? Naughty.
Oof yeah sorry about that. We never use timestamps as keys in the database itself, but I used it in a join to group maxes with their information. Oops, why did I do that? The actual post key is now used and this problem should be fixed.

I did some research and it looks like case insensitive logins are the norm. I had no idea; I always use all lowercase. Uhhh hm... I'll have to look at the database and see what I can do. The problem is that it was set up in the beginning to use case-sensitive operations (for some reason). This means that an insertion of a username into the database will be fine if the username has the same exact letters as another user but different capitalization. This is not something I can safely change at this point, but I'll look at different methods.

Are you sure you can't change it? I know it's a risky move, but it shouldn't be impossible if there aren't any two users with the same username.ToLowerCase() as of now. Which I somehow doubt there would be. Although again, there are some websites (although rare) that have case-sensitive login, but they make a point to mention this - usually in bold red text - after a single failed log-in attempt. If you just add that warning/notice, you can call the problem fixed. If I remember correctly Wikipedia is one site with case-sensitive usernames, so it's not completely unheard of. Edit: just checked Wikipedia, it surprisingly doesn't mention the case-sensitivity (at least on mobile) but the log in username IS case sensitive.