[rt-users] Rt at Glance and upgrade from 3.2.1 to 3.8.0

Jean-Michel Barbet Jean-Michel.Barbet at subatech.in2p3.fr
Tue Aug 12 02:55:17 EDT 2008


Jean-Michel Barbet wrote:

> The problem with accents is fixed. 

Sorry, I spoke too soon. I still have a problem with the column
"Content" of the Attachements table.

In RT 3.2.1/MySQL4.0 this column is longtext

The mysql upgrade scripts does this :

ALTER TABLE Attachments MODIFY Content LONGBLOB NULL DEFAULT NULL;

which results in corrupted accents

If I change back to LONGTEXT, it is OK.

=> What should I do ? Is is important that the type of this column
    is LONGBLOB in RT 3.8.0 and if yes, how do I convert from RT 3.2.1
    without corrupting the accents ?

Thanks and sorry to bring new issues.

JM



-- 
------------------------------------------------------------------------
Jean-michel BARBET                    | Tel: +33 (0)2 51 85 84 86
Laboratoire SUBATECH Nantes France    | Fax: +33 (0)2 51 85 84 79
CNRS-IN2P3/Ecole des Mines/Universite | E-Mail: barbet at subatech.in2p3.fr
------------------------------------------------------------------------



More information about the rt-users mailing list