Can you provide just wee bit more information? Such as: What is RT? What is the Perl Version (perl -V would be helpful output) What is the Database Version?
A Transcript of your build and install perl Makefile.PL, make make test Finally, if the solution is not obvious from your above output, and your database version is not very old, could you create a script (clone one of the tests in the t/ directory)to reproduces the problem? Then there would be a prayer of chance that someone with some knowledge might actually have an idea how to help you... or what to look at. BTW... I moved this to dbi-users, which is probably the better place to start when asking this kind of question. Most DBI devs also subscribe to dbi-users. Lincoln On Tue, 2004-11-30 at 16:22 -0500, Jesse Vincent wrote: > 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 ----- >