> I have to transfer the user preferences to another mailserver without > MySQL support. No access to a database server. I have to convert the BLOBs > into plain text files รก la email.prev - how? > > I know about the scripting, I only want to know how to make those binary > BLOBs readable by a human (me or rather the shell). > > It might be a MySQL question but I already wanted to ask why the SM > developers chose to use BLOB instead of TEXT? It makes administrative > tasks as setting (and reading) full_name and email_address quite > difficult. Or did I miss a clue?
According to documentation email, firstname and lastname fields use VARCHAR data type. BLOB is used only for label field. I think reasons are historical. MySQL supports TEXT only since 3.21.10. Or maybe it was done because TEXT data type is not standard SQL. > As you might already know I neither have experince with PHP nor with > binary data in databases and appreciate every hint to export my SM user > prefs to plain text files. When phpmyadmin exports table to csv, blob is converted to plain text. -- Tomas ------------------------------------------------------- All the advantages of Linux Managed Hosting--Without the Cost and Risk! Fully trained technicians. The highest number of Red Hat certifications in the hosting industry. Fanatical Support. Click to learn more http://sel.as-us.falkag.net/sel?cmd=lnk&kid=107521&bid=248729&dat=121642 -- squirrelmail-users mailing list Posting Guidelines: http://www.squirrelmail.org/wiki/MailingListPostingGuidelines List Address: [email protected] List Archives: http://news.gmane.org/thread.php?group=gmane.mail.squirrelmail.user List Archives: http://sourceforge.net/mailarchive/forum.php?forum_id=2995 List Info: https://lists.sourceforge.net/lists/listinfo/squirrelmail-users
