Issues with RT3.2.2 on MacOSX and Oracle

Heya.

Wonder if anyone has come across this. I’ve got an RT3.2.2 installation
that I’m trying to get going on Mac OS X (panther)

Everything is working,except creating tickets it is having issues
inserting into the Attachments table. I gather its an issue with
Unicode,

DBD::Oracle::st execute failed: ORA-12704: character set mismatch

I’ve been through the various Oracle google results, and most suggest
setting NLS_LANG, but RT seems to overwrite that in Handle.pm anyway, so
that’s not much help.

Anyone been bitten by this and know the fix?

Regards

Matthew Watson

Netspace Online Systems

(03) 98110010

This email and any files transmitted with it are confidential and intended solely for the
use of the individual or entity to whom they are addressed. Please notify the sender
immediately by email if you have received this email by mistake and delete this email
from your system. Please note that any views or opinions presented in this email are solely
those of the author and do not necessarily represent those of the organisation.
Finally, the recipient should check this email and any attachments for the presence of
viruses. The organisation accepts no liability for any damage caused by any virus
transmitted by this email.

FYI,

I finally solved this issue. It turned up on a AMD64 I was testing as
well, issue turned out to be DBD::Oracle 1.16, once I dropped back to
1.15 everything

worked fine. Haven’t looked into what the actual problem is yet, but if
anyone else is having this issue… that’s what it may be.

Regards,
Matt.From: rt-users-bounces@lists.bestpractical.com
[mailto:rt-users-bounces@lists.bestpractical.com] On Behalf Of Matthew
Watson
Sent: Wednesday, November 03, 2004 6:50 PM
To: rt-users@lists.fsck.com
Subject: [rt-users] Issues with RT3.2.2 on MacOSX and Oracle

Heya.

Wonder if anyone has come across this. I’ve got an RT3.2.2 installation
that I’m trying to get going on Mac OS X (panther)

Everything is working,except creating tickets it is having issues
inserting into the Attachments table. I gather its an issue with
Unicode,

DBD::Oracle::st execute failed: ORA-12704: character set mismatch

I’ve been through the various Oracle google results, and most suggest
setting NLS_LANG, but RT seems to overwrite that in Handle.pm anyway, so
that’s not much help.

Anyone been bitten by this and know the fix?

Regards

Matthew Watson

Netspace Online Systems

(03) 98110010

This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they are
addressed. Please notify the sender immediately by email if you have
received this email by mistake and delete this email from your system.
Please note that any views or opinions presented in this email are
solely those of the author and do not necessarily represent those of the
organisation. Finally, the recipient should check this email and any
attachments for the presence of viruses. The organisation accepts no
liability for any damage caused by any virus transmitted by this email.