I have as small issue.. I have a view with exposed filtering, and when typing Å it's interpeted as A by views. I understand why it's like that - but in norwegian Å is an unique character in the alphabet, and it doesn't make sens to read it as an A. Ø is not read as O, so it seems to only be a problem for the Å character. The same problem is when using regular filter (not exposed) so it's got nothing to do with special characters in the url.

I need to find out where this transliteration is done, so i can patch it. Been looking through the source files, but can't seem to find anything helpful.
I would really appreciate a push in the right direction here! What function is converting Å,À,Ä Â to A?

Comments

asund’s picture

asund commented

Is it maybe the sql LIKE statement that does this?

asund’s picture

asund commented
Status: Active » Closed (fixed)

That was it allright.
I made a new filter using RLIKE and a regular expression in stead.

I just needed to match the first character, so this is my filter:

 function op_first_char($field, $upper) {
    $this->query->add_where($this->options['group'], "UPPER(LEFT(%s,1)) RLIKE '(%s)'", $field, substr(strtoupper($this->value),0,1));
  }