Using RT with non-English (foreign characters) Emails

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.

-Ashish

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.

RT has been unicode-aware and unicode-safe since RT 3.0. (Chinese was
the first non-latin language we tested with, too.)

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?

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,
AshishFrom: rt-users-bounces@lists.bestpractical.com [rt-users-bounces@lists.bestpractical.com] On Behalf Of Emmanuel Lacour [elacour@easter-eggs.com]
Sent: Wednesday, January 21, 2009 12:31 AM
To: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] Using RT with non-English (foreign characters) Emails

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@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com

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.

-AshishFrom: Potla, Ashish Bassaliel
Sent: Wednesday, January 21, 2009 12:52 AM
To: Emmanuel Lacour
Cc: rt-users@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@lists.bestpractical.com [rt-users-bounces@lists.bestpractical.com] On Behalf Of Emmanuel Lacour [elacour@easter-eggs.com]
Sent: Wednesday, January 21, 2009 12:31 AM
To: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] Using RT with non-English (foreign characters) Emails

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@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com

What do you see when you use the link to “download”/view the “raw” transaction?

Cambridge Energy Alliance: Save money. Save the planet.

For the plaintext email: I see ‘?’ marks where ever I expect to see the foreign characters.
For the HTML Email : I have two Download buttons one for text/plain and another for text/html.
The text/plain is similar to the previous test; ‘?’ marks instead of foreign characters, But the text/html clearly displays the foreign characters.

Is this the extent of RT`s support for foreign characters?
The Subject in any case contains ‘?’ marks where foreign characters are expected.
-AshishFrom: Jerrad Pierce [jpierce@cambridgeenergyalliance.org]
Sent: Wednesday, January 21, 2009 1:32 AM
To: Potla, Ashish Bassaliel
Cc: Emmanuel Lacour; rt-users@bestpractical.com
Subject: Re: [rt-users] Using RT with non-English (foreign characters) Emails

What do you see when you use the link to “download”/view the “raw” transaction?

Cambridge Energy Alliance: Save money. Save the planet.

Found this within the last month. Might point you in the right direction.

Potla, Ashish Bassaliel wrote:

For the plaintext email: I see ‘?’ marks where ever I expect to see the foreign characters.
For the HTML Email : I have two Download buttons one for text/plain and another for text/html.
The text/plain is similar to the previous test; ‘?’ marks instead of foreign characters, But the text/html clearly displays the foreign characters.

Is this the extent of RT`s support for foreign characters?
The Subject in any case contains ‘?’ marks where foreign characters are expected.
-Ashish


From: Jerrad Pierce [jpierce@cambridgeenergyalliance.org]
Sent: Wednesday, January 21, 2009 1:32 AM
To: Potla, Ashish Bassaliel
Cc: Emmanuel Lacour; rt-users@bestpractical.com
Subject: Re: [rt-users] Using RT with non-English (foreign characters) Emails

What do you see when you use the link to “download”/view the “raw” transaction?


Cambridge Energy Alliance: Save money. Save the planet.


The rt-users Archives

Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com

Drew Barnes
Applications Analyst
Network Resources Department
Raymond Walters College
University of Cincinnati

Thanks much!
I was able to get it to work. Just added the ‘SetEnv NLS_LANG AMERICAN_AMERICA.UTF8’ in </> part of my httpd.conf file. Now I can see foreign characters(chinese japanese korean) in subject and in the body.

Thanks
AshishFrom: Drew Barnes [barnesaw@ucrwcu.rwc.uc.edu]
Sent: Wednesday, January 21, 2009 1:56 AM
To: Potla, Ashish Bassaliel
Cc: Jerrad Pierce; rt-users@bestpractical.com
Subject: Re: [rt-users] Using RT with non-English (foreign characters) Emails

Found this within the last month. Might point you in the right direction.

Potla, Ashish Bassaliel wrote:

For the plaintext email: I see ‘?’ marks where ever I expect to see the foreign characters.
For the HTML Email : I have two Download buttons one for text/plain and another for text/html.
The text/plain is similar to the previous test; ‘?’ marks instead of foreign characters, But the text/html clearly displays the foreign characters.

Is this the extent of RT`s support for foreign characters?
The Subject in any case contains ‘?’ marks where foreign characters are expected.
-Ashish


From: Jerrad Pierce [jpierce@cambridgeenergyalliance.org]
Sent: Wednesday, January 21, 2009 1:32 AM
To: Potla, Ashish Bassaliel
Cc: Emmanuel Lacour; rt-users@bestpractical.com
Subject: Re: [rt-users] Using RT with non-English (foreign characters) Emails

What do you see when you use the link to “download”/view the “raw” transaction?


Cambridge Energy Alliance: Save money. Save the planet.


The rt-users Archives

Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com

Drew Barnes
Applications Analyst
Network Resources Department
Raymond Walters College
University of Cincinnati