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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 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/

_______________________________________________
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/

Reply via email to