PDA

View Full Version : Capitalisation issue.


timbaxter
6-22-04, 07:39 AM
This is just an idle query really.

I am running two instances of the YaBB forum on my webpage (both share the same member list, but I doubt this would have any effect).

Since my second forum started, I've been somewhat inundated with queries from newbie members.

The problem is relating to the usernames being case-sensitive. For instance username "Andy" tries to log in as "andy" and is told that his account doesn't exist.

I was wondering, aside from leaving many many messages around the forum telling people that their usernames are case-sensitive, is there anything I can do from the server end to fix the problem?

(jj)
6-22-04, 05:25 PM
The case sensitivity is due to the operating system, so I really doubt there is anything that can be done from your end.

extras
6-22-04, 05:31 PM
If you know about the script, you may be able to identify
the code for authentication, and modify it.

For example, you can change all username input to
lowercase and put it in the user database.
When you check, you do same thing.
Convert it to the lowercase, and do authentication.

Relatively easy to do, depending on the script.

stevel
6-22-04, 05:42 PM
The case sensitivity is due to the operating system, so I really doubt there is anything that can be done from your end.No, it isn't - not in this context.

B&T
6-22-04, 06:48 PM
For the user name MySQL query to be case sensitive the element must be defined as binary. If the value is defined as character, then the MySQl query will not care. So I suppose you could redefine the element. Then Andy, andy AndY would all match.

timbaxter
6-22-04, 10:41 PM
Thank you. I had the impression that it was to do with the script itself.

On their support forums, they told me there's nothing I can do from the software end to rectify the issue.

I'm dealing with Perl which is beyond my areas of knowledge. But then, my areas of knowledge are pretty much limited to HTML, CSS and basic javascript.

Thanks. I'll keep hunting.