Case sensitivity (uppercase and lowercase should not be considered unique)
ascetic - November 11, 2008 - 22:29
| Project: | Unique field |
| Version: | 6.x-1.x-dev |
| Component: | Code |
| Category: | bug report |
| Priority: | normal |
| Assigned: | Unassigned |
| Status: | needs work |
Jump to:
Description
I'm using this module to create book reviews submitted by members. So the title has to be unique. the problem is sometimes they don't type it correctly (uppercase and lowercase). for example, I submit a book review entitled "Siddhartha" and other user submit the same book entitled "siddhartha", unique field consider them as a different value.
is it possible to add an option for uppercase and lowercase letters? so they are considered same value.
thanks a lot, a really unique module :)
#1
Hi ascetic,
Thanks for reporting this issue.
My intention is that this module does case-insensitive comparisons by default, so that 'Siddhartha' and 'siddhartha' are considered duplicate values. This is how the module works for me.
However, whether the comparison is case-sensitive or not may depend on your database software and configuration. For example, MySQL performs this comparison without case-sensitivity only since version 4.0. What database are you using?
In a future version I'd like to make this behavior explicit and provide the option to use case-sensitive comparisons if preferred.