Username validation against db

[daJunkCollector]

Hey. I am using mysql, php, and javascript (jquery).

I have a nice form setup where the username field validates AJAX-style against my database... this technique allows for the user to see if his username is already in use, while he is typing.

Problem is, I am only validating against the the exact (case-sensitive) value returned from the database. I want to make sure there can't be a user 'pete' and 'Pete'.

Any suggestions would be appreciated. ATTN: Moderators, this post may belong in either PHP or MySQL... I don't know if there is a fancy select statement I could use, or php method to compare against.

Thanks,
Pete

[daJunkCollector]

....i could ignore capitalization to begin with...?

[daJunkCollector]

sorry...been up too late. strtolower() will work.

[Dormilich]

that depends on your DB settings. just in case, there are uppercase and lowercase functions both in PHP and SQL.

you could also make a trial... (you know what users are already in the DB)