[SOLVED] Two MySQL questions

[jordanwb]

I have two questions (I guess you figured that out):

 

1) I have a field that is type INT whose length is 11 and it's unsigned. Does that mean its max value is 11 digits long (IE 99999999999) or that its max value is 2^11-1 (Max value would be 2047)?

 

2) In my register function in my website I found a potential problem. When a User registers it checks the users table for an existing username. But it checks only for the exact same username. For example:

 

In database: Jordanwb

user tries to register: jordanWB

 

As far as my script is concerned the new username does not exist in the database. How would I check for the same sequence of characters but ignore case in my SQL statement?

[jordanwb]

I found the answer to my first question. It's the number of digits.

[Gamic]

select UPPER(username) from user where username=UPPER('name');

if you get rows returned then you know they have the same characters, irrelevant of case.