OTRS5 UTF characters problem from Oracle DB

Moderator: crythias

Locked
bberet
Znuny newbie
Posts: 2
Joined: 04 Mar 2016, 15:48
Znuny Version: 5.0.7

OTRS5 UTF characters problem from Oracle DB

Post by bberet »

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?
bberet
Znuny newbie
Posts: 2
Joined: 04 Mar 2016, 15:48
Znuny Version: 5.0.7

Re: OTRS5 UTF characters problem from Oracle DB

Post by bberet »

setting $ENV{NLS_LANG} = "POLISH_POLAND.al32utf8"; in otrs/scripts/apache2-perl-startup.pl is the solution.
Locked