Hi,
I have fresh OTRS 5.0.7 with Oracle DB. After adding groups I observed that UTF-8 characters in group names are not displaying ater saving group.
I checked GROUPS table in DB and UTF8 characters are there. It looks like writing to database works fine, but when reading from DB characters are not encoded properly.
My DB settings:
NLS_LANGUAGE POLISH
NLS_TERRITORY POLAND
NLS_CHARACTERSET AL32UTF8.
I have also checked how sqlplus is returning characters and everything works fine (select returns UTF8 chars).
It looks like problem with DBD:Oracle. Any ideas?
OTRS5 UTF characters problem from Oracle DB
Moderator: crythias
Re: OTRS5 UTF characters problem from Oracle DB
setting $ENV{NLS_LANG} = "POLISH_POLAND.al32utf8"; in otrs/scripts/apache2-perl-startup.pl is the solution.