Brazilian charset problem

[spinaldf]

Dears,
I need help with charset problem. I don't have idea as I can resolve this problem.

My details: When I use otrs 5 no problem, but I update my otrs 5 to 6. I have several problems with charset.

Example:
Observac?es: ( Portuguese word incorrect)

Well Doesn't show correct.

The problems seem to be all related to accentuation.
Any suggestion?

[root]

Dears,
I need help with charset problem. I don't have idea as I can resolve this problem.

My details: When I use otrs 5 no problem, but I update my otrs 5 to 6. I have several problems with charset.

Example:
Observac?es: ( Portuguese word incorrect)

Well Doesn't show correct.

The problems seem to be all related to accentuation.
Any suggestion?

Hi,

What is the charset you're using? What is you're value for NLS_LANG?

- Roy

[spinaldf]

On apache doesn't existe this config, But I tried to add this options in "zzz_otrs.conf" file. But also doesn't work.

SetEnv LANG AMERICAN_AMERICA.WE8ISO8859P1
SetEnv NLS_LANG AMERICAN_AMERICA.WE8ISO8859P1
SetEnv NLS_NUMERIC_CHARACTERS=,

[spinaldf]

In oracle database.

SQL> SELECT value FROM nls_database_parameters where parameter='NLS_CHARACTERSET';

VALUE
--------------------------------------------------------------------------------
AL32UTF8

[root]

Hi,

Did you tried to put them into Kernel/Config.pm?

Code: Select all

$ENV{ORACLE_HOME}     = '/path/to/your/oracle';
$ENV{NLS_DATE_FORMAT} = 'YYYY-MM-DD HH24:MI:SS';
$ENV{NLS_LANG}        = 'AMERICAN_AMERICA.AL32UTF8';

- Roy

[spinaldf]

Yes, this configuration:

$ENV{ORACLE_HOME} = '/usr/lib/oracle/12.1/client64';
$ENV{NLS_DATE_FORMAT} = 'YYYY-MM-DD HH24:MI:SS';
$ENV{NLS_LANG}= 'AMERICAN_AMERICA.AL32UTF8';
$ENV{TNS_ADMIN}= '/opt/otrs/scripts';

[spinaldf]

I solved this problem.

I add this configuration in "apache2-perl-startup.pl" file:

###############################################
use strict;
use warnings;

# Make sure we are in a sane environment.
$ENV{MOD_PERL} =~ /mod_perl/ || die "MOD_PERL not used!";

--> $ENV{NLS_LANG} = "american_america.al32utf8";
--> $ENV{NLS_DATE_FORMAT} = 'YYYY-MM-DD HH24:MI:SS';
--> $ENV{TNS_ADMIN} = '/opt/otrs/scripts';

BEGIN {
###############################################
This is three lines and restart apache.

$ENV{NLS_LANG} = "american_america.al32utf8";
$ENV{NLS_DATE_FORMAT} = 'YYYY-MM-DD HH24:MI:SS';
$ENV{TNS_ADMIN} = '/opt/otrs/scripts';