[rt-users] Errors in apache logs after db migration.

[Potla, Ashish Bassaliel]

Hi All,
Over the weekend I have migrated the data on my db to another instance with the NLS_CHARSET to be AL32UTF8.

This I have done because, a new group of users from china has decided to use RT and they send emails with chinese characters in them. The db migration went well, I am able to see chinese characters getting stored in the db.

But when RT sends an email I see some problems crop up.

Scenario: 
On create
1. I have two scrips, one to notify admincc and one to send auto reply to requestor.
The auto replies are sent without any distortion but when it comes to the admincc email, the subject line is gibberish ie; its not chinese but some weird characters.

In the error_logs on apache I see a stack error as follows:

[Tue Mar  3 09:00:15 2009] [warning]: Use of uninitialized value in string eq at /opt/prj/rt/rt3/lib/RT/Record.pm line 1701. (/opt/prj/rt/rt3/lib/RT/Record.pm:1701)
[Tue Mar  3 09:00:22 2009] [error]: Could not convert attachment from assumed utf8 to 'gb2312' :Cannot decode string with wide characters at /opt/prj/rt/perl-5.8.8/lib/5.8.8/sun4-solaris-thread-multi/Encode.pm line 186.

Stack:
  [/opt/prj/rt/perl-5.8.8/lib/5.8.8/sun4-solaris-thread-multi/Encode.pm:186]
  [/opt/prj/rt/rt3/lib/RT/Attachment_Overlay.pm:300]
  [/opt/prj/rt/rt3/local/lib/RT/Action/SendEmail.pm:399]
  [/opt/prj/rt/rt3/local/lib/RT/Action/SendEmail.pm:140]
  [/opt/prj/rt/rt3/lib/RT/Action/Notify.pm:67]
  [/opt/prj/rt/rt3/lib/RT/ScripAction_Overlay.pm:234]
  [/opt/prj/rt/rt3/lib/RT/Scrip_Overlay.pm:478]
  [/opt/prj/rt/rt3/lib/RT/Scrips_Overlay.pm:239]
  [/opt/prj/rt/rt3/lib/RT/Transaction_Overlay.pm:173]
  [/opt/prj/rt/perl-5.8.8/lib/site_perl/5.8.8/Hook/LexWrap.pm:41]
  [/opt/prj/rt/rt3/lib/RT/Record.pm:1461]
  [/opt/prj/rt/rt3/lib/RT/Ticket_Overlay.pm:746]
  [/opt/prj/rt/rt3/lib/RT/Interface/Email.pm:730]
  [/opt/prj/rt/rt3/share/html/REST/1.0/NoAuth/mail-gateway:61] (/opt/prj/rt/rt3/lib/RT/Attachment_Overlay.pm:302)

This didnt happen when I was testing in development arena..  but is happening on production.
I have upgraded the Encode module to v2.26, the same I have on dev server.

I use: RT 3.6.5 on Oracle.
Any help or suggestions or thoughts wouldl be great!!

Best Regards,
-Ashish