[rt-users] Latin Characters

Joop JoopvandeWege at mococo.nl
Thu Dec 18 03:03:30 EST 2008


Hello Eliezer,

>> I installed RT as a solution to remove Remedy's AR in my company, but i'm
>> having some troubles displaying spanish accented characters like á é í ó ú
>> or ñ, so, if anybody has any ideas, will be very appreciated
>>     
> Do you have something like "AddDefaultCharset UTF-8" in your apache
> configuration?
>   

I'm running RT also with Oracle as a backend and I modified my 
/etc/init.d/apache2. The first couple of lines read as follows:
==
#!/bin/sh -e
#
# apache2        This init.d script is used to start apache2.
#            It basically just calls apache2ctl.

ENV="env -i LANG=C PATH=/usr/local/bin:/usr/bin:/bin 
NLS_LANG=AMERICAN_AMERICA.UTF8"
 ==

Notice the NLS_LANG at the end. That solved my problems with accented 
characters in the database.
Specifying it in httpd.conf might work. I never have tried it. If you 
don't specify NLS_LANG in you environment the OCI (DBD::Oracle) will 
fallback to the OS default which for most of us will be LANG=C which 
doesn't know about accented characters. Correct me if I'm wrong.

Regards,

Joop





More information about the rt-users mailing list