Today I found bug on my website while using MySQL query.
I just realized that the search function works in case insensitive.
If I execute this query:
SELECT filename FROM data_ebook WHERE filename = 'Manasik_Haji_dan_Umroh.pdf'
the results will be:
—
Manasik_Haji_dan_Umroh.pdf
Manasik_Haji_Dan_Umroh.pdf
—
By using keyword ‘LIKE BINARY’ it can make the result case sensitive:
SELECT filename FROM data_ebook WHERE filename LIKE BINARY 'Manasik_Haji_dan_Umroh.pdf'