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\" |<html
xmlns:v=\"urn:schemas-microsoft-com:vml\"
xmlns:o=\"urn:schemas-microsoft-com:office:office\"
xmlns:w=\"urn:schemas-microsoft-com:office:word\"
xmlns:st1=\"urn:schemas-microsoft-com:office:smarttags\"
xmlns=\"http://www.w3.org/TR/REC-html40\">
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\"
<html xmlns:v=\"urn:schemas-microsoft-com:vml\"
xmlns:o=\"urn:schemas-microsoft-com 01/10/08 17:03:03 1 01/10/08
17:03:03 1
:office:office\" xmlns:w=\"urn:schemas-microsoft-com:office:word\"
xmlns:st1=\"urn:s
chemas
But the attachment is not readable, and if i try to add the same
attachment via OTRS (migrated to Oracle) I have this :
ADMGNDEV> 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