[rt-users] Oracle and special German characters

[Peer Michael]

Thanks for the quick reply.

I tested your suggestion, but nothing changed. 

Michael 

-----Original Message-----
From: Joop [mailto:JoopvandeWege at mococo.nl] 
Sent: Tuesday, 25 September, 2007 09:24
To: Peer Michael
Cc: rt-users at 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