hi.
im use otrs 2.4.X with utf-8 as default charset and im try to use database with latin1 encoding as customers information backend.
otrs in log write:
Message: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation 'like', SQL: 'SELECT EMail , Imie, Nazwisko, EMail FROM Klienci WHERE ((LOWER(EMail) LIKE LOWER('xxx@xxx.pl') OR LOWER(Nazwisko) LIKE LOWER('xxx@xxx.pl') OR LOWER(Imie) LIKE LOWER('xxx@xxx.pl')) ) LIMIT 25'
when im add "mysql_enable_utf8 => 0," option to my DSN, im get no error in log hovever im get do data too.
person who im seek is in DB.
when i'm using otrs with iso-8859-1 as default encoding ewerythink work fine.
Customer DB in latin1
Moderator: crythias