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 ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
RE: [rt-users] Oracle and special German characters
Thanks for the quick reply. I tested your suggestion, but nothing changed. Michael -Original Message- From: Joop [mailto:[EMAIL PROTECTED] 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 ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
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 ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
[rt-users] Oracle and special German characters
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 ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com