Hello,
I would like to make the DaDaBiK searches to be case insensitive. At the moment all my searches are case sensitive.
I understand that there may be some control over this done by the mysql server, so I did the following.
I switched on $display_sql = 1; in config.php and ran a search in DaDaBiK.
the relevant part of the DaDaBiK sql was:-
WHERE `phpbb_users`.`username` LIKE '%david%'
DaDaBiK returns just the one username that contains "david_xxx"
If I change the DaDaBiK search and search for :-
WHERE `phpbb_users`.`username` LIKE '%David%'
I see a dozen or so results with the capitalised "DavidXxx"
If I switch to phpMyAdmin on the same database table and run the following sql:-
SELECT * FROM `phpbb_users` WHERE `phpbb_users`.`username` LIKE "%david%"
phpMyAdmin returns many records. As well as the "david_xxx" one, I see a dozen or so "DavidXxx", "DavidYyy" and so on.
So it seems like the DaDaBiK search is case sensitive where the phpMyAdmin search is not case sensitive.
I would like DaDaBiK to return the dozen or so mixed case records with a non case sensitive search.
Many thanks for your advice,
David.
I would like to make the DaDaBiK searches to be case insensitive. At the moment all my searches are case sensitive.
I understand that there may be some control over this done by the mysql server, so I did the following.
I switched on $display_sql = 1; in config.php and ran a search in DaDaBiK.
the relevant part of the DaDaBiK sql was:-
WHERE `phpbb_users`.`username` LIKE '%david%'
DaDaBiK returns just the one username that contains "david_xxx"
If I change the DaDaBiK search and search for :-
WHERE `phpbb_users`.`username` LIKE '%David%'
I see a dozen or so results with the capitalised "DavidXxx"
If I switch to phpMyAdmin on the same database table and run the following sql:-
SELECT * FROM `phpbb_users` WHERE `phpbb_users`.`username` LIKE "%david%"
phpMyAdmin returns many records. As well as the "david_xxx" one, I see a dozen or so "DavidXxx", "DavidYyy" and so on.
So it seems like the DaDaBiK search is case sensitive where the phpMyAdmin search is not case sensitive.
I would like DaDaBiK to return the dozen or so mixed case records with a non case sensitive search.
Many thanks for your advice,
David.