Hi Jeff,
that's a nice piece of work you're pulling off there!
Am I correct if I think you're asking how to base64-encode data that's
already there?
If you're on Oracle, you can use Java for it:
http://wiki.oracle.com/thread/1668760/Base64+Encoding%2FDecoding+from+PL%2FS...
But if you'd ask me I'd prefer to move the articles out of the
database by switching to ArticleStorageFS. It's much faster and
usually makes your DBA's happier because it's less LOB storage in the
database.
Can you share the process you used to do this conversion?
Regards,
Mike.
On Tue, Oct 26, 2010 at 3:59 AM, Jeff Travers
We converted our OTRS installation from MySQL to Oracle. For the most part, the migration was successful. The only issue we are having is that the "Content" column in the Article_Attachment table needs to be encoded in BASE64. Is there an easy method in which to accomplish this conversion? Is there a DB-Update script we could modify in order to encode the data in this column to BASE64?
--------------------------------------------------------------------- OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs