[rt-users] Using RT with non-English (foreign characters) Emails

[Potla, Ashish Bassaliel]

Hi, Just want to add some more observations:
The prior case (where ? marks show up ) is when I send plain text email.

If I send a HTML Email with the same content, 
In Web UI:
The foreign characters in the Subject line are replaced by ? marks
The foreign characters in the body of the email are replaced by junk values. No matter what I try to set the 'encoding type' on my FF, I cant display the correct foreign characters in the body text of the email.

-Ashish
________________________________________
From: Potla, Ashish Bassaliel
Sent: Wednesday, January 21, 2009 12:52 AM
To: Emmanuel Lacour
Cc: rt-users at bestpractical.com
Subject: RE: [rt-users] Using RT with non-English (foreign characters)  Emails

Hi Emmanuel,
->What database are you using? What is the character set of your DB?
I am using Oracle Database .

My NLS_DATABASE_PARAMETERS are

NLS_LANGUAGE                   AMERICAN
NLS_TERRITORY                  AMERICA
NLS_CURRENCY                   $
NLS_ISO_CURRENCY               AMERICA
NLS_NUMERIC_CHARACTERS         .,
NLS_CHARACTERSET               AL32UTF8
NLS_CALENDAR                   GREGORIAN
NLS_DATE_FORMAT                DD-MON-RR
NLS_DATE_LANGUAGE              AMERICAN
NLS_SORT                       BINARY
NLS_TIME_FORMAT                HH.MI.SSXFF AM
NLS_TIMESTAMP_FORMAT           DD-MON-RR HH.MI.SSXFF AM
NLS_TIME_TZ_FORMAT             HH.MI.SSXFF AM TZR
NLS_TIMESTAMP_TZ_FORMAT        DD-MON-RR HH.MI.SSXFF AM TZR
NLS_DUAL_CURRENCY              $
NLS_COMP                       BINARY
NLS_LENGTH_SEMANTICS           BYTE
NLS_NCHAR_CONV_EXCP            FALSE
NLS_NCHAR_CHARACTERSET         AL16UTF16
NLS_RDBMS_VERSION              10.2.0.3.0

->Can you see chinese chars on web RT interface?
NO

->What is the content of sent emails if you look at the web UI?
I see question marks where I expect to see the foreign characters.

->Does your client has utf-8 support with fonts that includes utf-8 chinese chars?
I am using Oracle 10_2 client, and I have no idea how to check this. Can you point me in the right direction?

I have RT running on a solaris box and the RT DB is on a different server.

Thanks in advance,
Ashish
________________________________________
From: rt-users-bounces at lists.bestpractical.com [rt-users-bounces at lists.bestpractical.com] On Behalf Of Emmanuel Lacour [elacour at easter-eggs.com]
Sent: Wednesday, January 21, 2009 12:31 AM
To: rt-users at lists.bestpractical.com
Subject: Re: [rt-users] Using RT with non-English (foreign characters)  Emails

On Tue, Jan 20, 2009 at 08:57:17AM -0800, Potla, Ashish Bassaliel wrote:
> Hello Everyone,
>
> Has anybody here used RT with non-English Emails? I am trying to set up a queue for incoming Chinese Emails as requests.
>
> But all I see in the content of the mail sent to AdminCCs by RT is '?' marks.
>

It should work. What database are you using? What is the character set
of your DB?

Can you see chinese chars on web RT interface?

What is the content of sent emails if you look at the web UI?

Does your client has utf-8 support with fonts that includes utf-8
chinese chars?
_______________________________________________
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