In doing a DB conversion I’ve run into an issue which doesn’t seem to be
discussed on the wiki.
RT/MySQL stores binary attachments as is, and MySQL seems to treat 'string’
as ‘string of bytes’.
However, on Postgres, RT creates a unicode Pg DB, and Postgres treats
’string’ as ‘string of UTF-8 Unicode characters’ - so RT needs to base64 the
binary attachments.
I’m wondering if anyone already has some conversion code for this, or
whether I should write some.
Max.