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%2FSQL 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 <[email protected]> wrote: > 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 > --------------------------------------------------------------------- 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
