Hi all, Do any one knows how to make find_by method case sensitive?
Thanks in advance, Mostafa Badawi
Hi all, Do any one knows how to make find_by method case sensitive?
Thanks in advance, Mostafa Badawi
Hi
Do any one knows how to make /find_by/ method case sensitive?
Case sensitivity doesn't depend on rails, but on your DBMS settings.
Assuming you are using mysql, the default encoding/collation are latin1 and latin1_swedish_ci where "_ci" stands for "case insensitive".
If you want to run all your queries in a case sensitive way, you can just change the encoding of your database or of that particular table or column.
If you want to use it in a single query, you can use the COLLATE operator as a part of your condition and specify a case sensitive collation.
If you are not using MySQL, still the theory is the same, but the details will change
good luck,