[rt-users] RT 3.2.2 and Oracle

[m_germann at bluemail.ch]

Hi
I'm trying to run RT 3.2.2 on Solaris 8 with Oracle.
I was able to initialize the database, and login
as root. When I try to setup a new user, I get the
following error in the logs:

stderr: DBD::Oracle::st execute failed:
ORA-12704: character set mismatch (DBD ERROR: error possibly near <*> indicator
at char 394 in 'INSERT INTO Users (NickName, Comments, Address2, WebEncoding,
FreeformContactInfo, City, RealName, AuthSystem, State, EmailEncoding, EmailAddress,
Password, Signature, MobilePhone, WorkPhone, Zip, id, ExternalContactInfoId,
LastUpdated, PagerPhone, Organization, ContactInfoSystem, Lang, Creator,
Gecos,
HomePhone, LastUpdatedBy, Country, Address1, Created, Name, ExternalAuthId)
VALUES...

The same thing happens when replying to a ticket:

stderr: DBD::Oracle::st execute failed:
ORA-12704: character set mismatch (DBD ERROR: error possibly near <*> indicator
at char 171 in 'INSERT INTO Attachments (ContentType, Parent, id, Subject,
Filename, Headers, Creator, Created, Content, ContentEncoding, TransactionId)
VALUES...


Oracle uses character set WE8ISO8859P1, tried to change NLS_LANG without
success.
Any ideas?

Thanks,
Martin