
Well, I have found some other weird problems that have something to do with character sets. First off I will state that my character set for oracle is iso-8859-1 and the national one is set to AL16UTF16. OTRS is set to iso-8859-1. I edited the question marks that had replaced that French characters in the database using a program called TOAD. I could view the data properly using toad after I had committed the changes. Now when I compose an email in OTRS the signature has regular characters replacing the French ones with the accents and such above them. Another issue is that if I change OTRS's character set to UTF-8 and insert French characters into the subject of an email I receive the error below. I can insert them into the body of the email but not the subject. When I insert them into the body of the email then they return to the regular characters without the accent. Anyone have the thoughts about my problem? Dan Error: Can't get ArticleID from INSERT! Traceback: ERROR: OTRS-CGI-10 Perl: 5.8.8 OS: solaris Time: Fri Aug 10 15:21:08 2007 Message: Can't get ArticleID from INSERT! Traceback (21410): Module: Kernel::System::Ticket::Article::ArticleCreate (v1.144) Line: 152 Module: Kernel::Modules::AgentTicketPhone::Run (v1.45) Line: 679 Module: Kernel::System::Web::InterfaceAgent::Run (v1.22) Line: 670 Module: Apache::ROOT::otrs::index_2epl::handler (v1.81) Line: 47 Module: (eval) (v2.01) Line: 149 Module: Apache::Registry::handler (v2.01) Line: 149 ________________________________ From: otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] On Behalf Of Laurent Minost Sent: Friday, August 10, 2007 12:16 PM To: User questions and discussions about OTRS.org Subject: Re: [otrs] French characters Hi, I'm a french user of OTRS and personnaly I always set iso-8859-1, otherwise I have this type of problems with UTF-8 ... :o( Best regards, Laurent Le vendredi 10 août 2007 à 11:57 -0400, Dan King a écrit : Hello list, I am trying to have text that includes French characters such as the one below. The problem seems to be that when you commit something to the database any French characters end up being inserted or converted in the columns of the database as question marks. É é é é é turns into ? ? ? ? ? Does anyone know what is wrong? I have set the default character set to utf-8 but that didn't work. I am using OTRS 2.2.2 with an oracle 10g backend. Thanks for any help required. Dan King _______________________________________________ OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs Support or consulting for your OTRS system? => http://www.otrs.com/