case sensitive

[dab42pat]

Hi

I know very little about javascript. I downloaded this script to search a database however it is case sensitive and only picks up anything from the database that starts with capital letter I type in the search box.

Is their anyway I can change the code so it is not case sensitive.

Cheers

Pat

Code: Select all

function createObject() {
    
    var request_type;
    var browser = navigator.appName;
    if(browser == "Microsoft Internet Explorer"){
    request_type = new ActiveXObject("Microsoft.XMLHTTP");
    }else{
        request_type = new XMLHttpRequest();
    }
        return request_type;
}

var http = createObject();

/* -------------------------- */
/* SEARCH                     */
/* -------------------------- */

function autosuggest() {
q = document.getElementById('search-q').value;

// Set te random number to add to URL request
nocache = Math.random();
http.open('get', 'lib/search.php?q='+q+'&nocache = '+nocache);
http.onreadystatechange = autosuggestReply;
http.send(null);
}
function autosuggestReply() {
if(http.readyState == 4){
    var response = http.responseText;
    e = document.getElementById('results');
    if(response!=""){
        e.innerHTML=response;
        e.style.display="block";
    } else {
        e.style.display="none";
    }
}
}

[CloudedVision]

All that script does is get the results from lib/search.php, so you'll have to mess around with that to fix it.

[dab42pat]

Thanks Clouded, However the problem wasnt in javascript or PHP, It was in the database itself.

The field it was searching had its collation set to Latin1_bin so I changed it to utf8_unicode_ci the ci sort of gives it away case insensitive .

Anyway thanks for your help

Pat