[rt-users] Latin Characters

[Eliezer E Chávez]

Uh

But i defined the variables in the env
and used

PassEnv ORACLE_HOME
PassEnv LD_LIBRARY_PATH
PassEnv NLS_LANG
PassEnv TNS_ADMIN

in httpd.conf

On Thu, Dec 18, 2008 at 4:58 AM, Emmanuel Lacour <elacour at easter-eggs.com>wrote:

> 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: sales at bestpractical.com
>
>
> Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
> Buy a copy at http://rtbook.bestpractical.com
>



-- 
Eliezer E Chávez
+58-416-6125676
eliezer.chavez at gmail.com
>>http://www.bumeran.com.ve/cv/eliezer-chavez
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20081218/387250f5/attachment.htm>