On Thu, Dec 18, 2008 at 09:03:30AM +0100, Joop wrote: > 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" > == >
Shouldn't be needed as this is explicitely defined in RT (lib/RT/Handle.pm): sub Connect { my $self = shift; my $db_type = RT->Config->Get('DatabaseType'); if ( $db_type eq 'Oracle' ) { $ENV{'NLS_LANG'} = "AMERICAN_AMERICA.AL32UTF8"; $ENV{'NLS_NCHAR'} = "AL32UTF8"; } The AddDefaultCharset in apache config is not for database connection, but for http headers. _______________________________________________ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com