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
Support from Acquia helps fund testing for Drupal Acquia logo

Comments

dawehner’s picture

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

Is it possible to fix this issue?

dawehner’s picture

Status: Active » Needs review
FileSize
1.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

Issue summary: View changes

Mistype is fixed.

maximpodorov’s picture

Issue summary: View changes

mistype is fixed

MustangGB’s picture

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