Hi All, A number of my users running RT against Oracle seem to be having issues with UTF8 support and DBD::Oracle 1.16.
Pretty much any INSERT that touches a CLOB generates the following error: DBD::Oracle::st execute failed: ORA-12704: character set mismatch The database's native encoding doesn't seem to matter and RT is setting NLS_LANG to ".UTF8". Dropping back to 1.15 seems to fix the issue. Does this ring a bell for anyone? Jesse From: Matthew Watson <[EMAIL PROTECTED]> 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. From: [EMAIL PROTECTED] Sent: Wednesday, November 03, 2004 6:50 PM To: [EMAIL PROTECTED] 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. _______________________________________________ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Be sure to check out the RT wiki at http://wiki.bestpractical.com ----- End forwarded message ----- --