Early Bird Registration for DrupalCon Portland 2024 is open! Register by 23:59 PST on 31 March 2024, to get $100 off your ticket.
For multi-byte characters, LENGTH works incorrectly in MySQL, and CHARACTER_LENGTH must be used instead.
Currently, "Length is shorter than" and similar filters work incorrectly with MySQL and non-ASCII characters.
Unfortunately, different RDBMSes use different function names for the string length:
http://en.wikibooks.org/wiki/SQL_Dialects_Reference/Functions_and_expres...
Comment | File | Size | Author |
---|---|---|---|
#3 | 1263238-char_length.patch | 1.64 KB | dawehner |
Comments
Comment #1
dawehnerThis seems to be a reasonable bug report. Damn databases can't you just decide and compete on the technical design level?
Comment #2
maximpodorov CreditAttribution: maximpodorov commentedIs it possible to fix this issue?
Comment #3
dawehnerWell sure in theory it's possible but the amount of time is finally, not sure about the space...
Back to drupal i hoped in d7 there is some kind of mechanism in dbtng already but it seems not to be.
Here is a patch which should be possible to fix this issue and provide a base for other fixes and a d7 version.
Comment #3.0
dawehnerMistype is fixed.
Comment #3.1
maximpodorov CreditAttribution: maximpodorov commentedmistype is fixed
Comment #4
MustangGB CreditAttribution: MustangGB commented