Case Sensitive problem:(

[Anon]

Hi there,

I have a login screen connecting to my vbulletin database that allows users to log into other areas of the site using the same password as the forums.

The problem is, the loginnames/passwords in the vbulletin users table are all not formatted to upper/lower case, they are formatted just how the user entered them (e.g JoeBloggs). As a result, my login screen is case sensitive🙁

I dont want it to be case sensitive, as i am getting complaints from users by the second!any ideas?

Jonathan

[Anon]

I know in oracle you can use the function LOWER() and UPPER() in your SQL queries, but I am not sure if they are normal SQL functions or Oracle specific functions.