Hi all, I try to migrate our OTRS database from mysql to Oracle. We are using OTRS 2.3.1, the migration process is done with the scripts generated by sqldevelopper, the processes are: 1) mysqldump --> dumps data to text file 2) create schema in oracle using the otrs-schema.oracle.sql 3) sqlldr (sql loader) to import data from the text file 4) Recreate sequences All seems fine, but I have a problem with attachments: Example on an HTML attachment: Source : mysql> select * from article_attachment WHERE article_id = 4633 AND id=2508; | 2508 | 4633 | file-2 | 28057 | text/html; charset=\"windows-1258\" |http://www.w3.org/TR/REC-html40\http://www.w3.org/TR/REC-html40%5C "> Target seems well imported: ADMGNDEV> select * from article_attachment WHERE article_id = 4633 AND id=2508; 2508 4633 file-2 28057 text/html; charset=\"windows-1258\" select * from article_attachment WHERE article_id = 100050; 100058 100050 file-2.html 28057 application/octet-stream PGh0bWwgeG1sbnM6dj0idXJuOnNjaGVtYXMtbWljcm9zb2Z0LWNvbTp2bWwiIHhtbG5zOm89InVy 15/10/08 10:47:07 2 15/10/08 10:47:07 2 bjpzY2hlbWFzLW1pY3Jvc29mdC1jb206b2ZmaWNlOm9mZmljZSIgeG1sbnM6dz0idXJuOnNjaGVt YXMtbWljcm9zb2Z0LWNvbTpvZmZpY2U6d29yZCIgeG1sbnM6c3QxPSJ1cm46c2NoZW1hcy1taWNy Do you have any idea, why under Oracle, OTRS encodes all attachments using \"application/octet-stream\", and do you know anyway to convert text (text/html; charset=\"windows-1258\") to octet (\"application/octet-stream\")? Hope this clear, don\'t hesitate to ask details. Thank for your answer. Regards, Bastien. -- Bastien Leblanc email: bastien@tribuleblanc.com Site : http://bastien.tribuleblanc.com Enfants: http://www.travisjudith.info