Oracle and special German characters

RT Users
1

Hello!

We are testing RT with oracle database. Everything works fine, but I
have problems with special German characters. RT doesn’t show this
characters in the right mode. He substitute this characters with other
characters.
Does someone of you has any experience with RT and oracle?

We are using:
rt-3.4.5
oracle 9i
DBIx::SearchBuilder v1.45

2

Peer Michael wrote:

Hello!
We are testing RT with oracle database. Everything works fine, but I
have problems with special German characters. RT doesn’t show this
characters in the right mode. He substitute this characters with other
characters.
Does someone of you has any experience with RT and oracle?
We are using:
rt-3.4.5
oracle 9i
DBIx::SearchBuilder v1.45
I added/replaced the following to my /etc/int.d/apache2, about the 4-5
line from above:
ENV=“env -i LANG=C PATH=/usr/local/bin:/usr/bin:/bin
NLS_LANG=AMERICAN_AMERICA.UTF8”

The added stuff is about NLS_LANG, adjust to your database settings.

Joop

3

Thanks for the quick reply.

I tested your suggestion, but nothing changed.

MichaelFrom: Joop [mailto:JoopvandeWege@mococo.nl]
Sent: Tuesday, 25 September, 2007 09:24
To: Peer Michael
Cc: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] Oracle and special German characters

Peer Michael wrote:

Hello!
We are testing RT with oracle database. Everything works fine, but I
have problems with special German characters. RT doesn’t show this
characters in the right mode. He substitute this characters with other

characters.
Does someone of you has any experience with RT and oracle?
We are using:
rt-3.4.5
oracle 9i
DBIx::SearchBuilder v1.45
I added/replaced the following to my /etc/int.d/apache2, about the 4-5
line from above:
ENV=“env -i LANG=C PATH=/usr/local/bin:/usr/bin:/bin
NLS_LANG=AMERICAN_AMERICA.UTF8”

The added stuff is about NLS_LANG, adjust to your database settings.

Joop

4

Peer Michael wrote:

Thanks for the quick reply.

I tested your suggestion, but nothing changed.

I presume that you restarted apache and that your database charset is
indeed capable of supporting german characters and things like �� etc.
Because I just checked my only rt-3.4.5 environment and couldn’t find
any modification except the ENV line in /etc/init.d/apache2

Joop

5

Hello

I added follow line in the RT_SiteConfig:
Set($ENV{‘NLS_LANG’} = ‘AMERICAN_AMERICA.UTF8’);

Now it works.

Thanks

MichaelFrom: Joop [mailto:JoopvandeWege@mococo.nl]
Sent: Tuesday, 25 September, 2007 13:04
To: Peer Michael
Cc: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] Oracle and special German characters

Peer Michael wrote:

Thanks for the quick reply.

I tested your suggestion, but nothing changed.

I presume that you restarted apache and that your database charset is indeed capable of supporting german characters and things like éí etc.
Because I just checked my only rt-3.4.5 environment and couldn’t find any modification except the ENV line in /etc/init.d/apache2

Joop