Closed (outdated)
Project:
Unique field
Version:
6.x-1.4
Component:
Code
Priority:
Major
Category:
Bug report
Assigned:
Unassigned
Reporter:
Created:
11 Oct 2011 at 16:34 UTC
Updated:
18 Apr 2024 at 08:55 UTC
Jump to comment: Most recent
I use this module in a simple Drupal setup to ensure the uniqueness of node titles.
There are two problems, however.
The problem depends on the string types in the MySQL tables. See case sensitivity in string searches.
I assume that certain setups are not affected because they create database tables with binary strings.
I think the module should ensure that strings are compared using BINARY string representations.
See the BINARY Operator.
The solution is simple: $qwhere = "BINARY node.title = '". db_escape_string($values) ."' ";
I think other text fields should also be treated this way.
Comments
Comment #1
astonvictor commentedI'm closing it because the issue was created a long time ago without any further steps.
if you still need it then raise a new one.
thanks