In JavaScript, I'm trying using the user's input to search my database. For example, user input is "monster", and my database's data is "Monster". How can I have it match regardless of it's casing?
-
Are you looking for something like this: stackoverflow.com/questions/177719/…zengr– zengr2010-04-12 00:20:17 +00:00Commented Apr 12, 2010 at 0:20
-
@zengr I don't think that's what they're looking for. This regards searching a database as opposed to searching the string :DGordon Gustafson– Gordon Gustafson2010-04-12 00:22:09 +00:00Commented Apr 12, 2010 at 0:22
Add a comment
|
4 Answers
Javascript string case-insensitive comparisons can be performed with string.toUpperCase.
if (input.toUpperCase() === "OTHER STRING")
....
(I'm assuming your database example is just an example as databases usually ignore the case of strings :)
answered Apr 12, 2010 at 0:19
Gordon Gustafson
41.4k25 gold badges119 silver badges160 bronze badges
Comments
Use match() instead of search().
Comments
You should convert both javascript string and database where clause to use lower case string.
But I guess database like sql server and mysql are all case insensitive in terms of string.
Comments
If you're using AJAX then you're using a server side language. Why don't you let the server side script normalize the data?. You could even delegate this task to the database, using the proper UPPER and LOWER functions, but for security reasons data normalization should be a task for the server side script.
You can use JS to pre-check the data in terms of length and syntaxes, mostly for helping and preventing the user from making mistakes, but one thing you should never do is query untreated JS data. Anyone could manipulate the JS and query a' OR 1=1; DROP TABLE users;--, even if you validate the data.
