Wrong comparison of accented characters in strings

Created on 11 October 2011, about 13 years ago
Updated 18 April 2024, 8 months ago

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.

🐛 Bug report
Status

Closed: outdated

Version

1.4

Component

Code

Created by

🇭🇺Hungary mtcs

Live updates comments and jobs are added and updated live.
Sign in to follow issues

Comments & Activities

  • 🇺🇦Ukraine AstonVictor

    I'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

Production build 0.71.5 2024