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...

CommentFileSizeAuthor
#3 1263238-char_length.patch1.64 KBdawehner

Comments

dawehner’s picture

dawehner
Primary language German
commented

This seems to be a reasonable bug report. Damn databases can't you just decide and compete on the technical design level?

maximpodorov’s picture

maximpodorov commented

Is it possible to fix this issue?

dawehner’s picture

dawehner
Primary language German
commented
Status: Active » Needs review
StatusFileSize
new 1263238-char_length.patch1.64 KB

Well 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.

dawehner’s picture

dawehner
Primary language German
commented
Issue summary: View changes

Mistype is fixed.

maximpodorov’s picture

maximpodorov commented
Issue summary: View changes

mistype is fixed

mustanggb’s picture

mustanggb commented
Issue summary: View changes
Status: Needs review » Closed (won't fix)