[rt-users] MySQL->Postgres - an issue not mentioned on the wiki page.

[Max Bowsher]

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.