when i am using sql query to retrieve from the db using SELECT * FROM table WHERE rs(name)='"name"' it also retieves Name,NAME etc from the db
I want my qeury to be case sensitive how do i do it?
regards and thanks in advance kiran
You'll need to convert the column with data you're searching in, to a blob (BINARY Large OBject) and the binary part is what makes the difference.
If you are using mysql 3.23 (don't know about earlier versions) you can make your searches case sensitive by defining them as "binary" in your query (without changing your table setup)
SELECT * FROM table WHERE BINARY name LIKE "Part%";
