This is the output in the new database
CREATE TABLE Attachments
(\n id
int(11) NOT NULL auto_increment,\n
TransactionId
int(11) NOT NULL,\n Parent
int(11) NOT NULL default
‘0’,\n MessageId
varchar(160) character set ascii default NULL,\n
Subject
varchar(255) default NULL,\n Filename
varchar(255) default
NULL,\n ContentType
varchar(80) character set ascii default NULL,\n
ContentEncoding
varchar(80) character set ascii default NULL,\n
Content
longblob,\n Headers
longtext,\n Creator
int(11) NOT NULL
default ‘0’,\n Created
datetime default NULL,\n PRIMARY KEY (id
),\n
KEY Attachments2
(TransactionId
),\n KEY Attachments3
(Parent
,TransactionId
)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8
For the old database, I used the backup (an export from phpMyAdmin) and
did an import in the same server. Here is the output:
CREATE TABLE Attachments
(\n id
int(11) NOT NULL auto_increment,\n
TransactionId
int(11) NOT NULL,\n Parent
int(11) NOT NULL default
‘0’,\n MessageId
varchar(160) default NULL,\n Subject
varchar(255)
default NULL,\n Filename
varchar(255) default NULL,\n ContentType
varchar(80) default NULL,\n ContentEncoding
varchar(80) default
NULL,\n Content
longtext,\n Headers
longtext,\n Creator
int(11)
NOT NULL default ‘0’,\n Created
datetime default NULL,\n PRIMARY KEY
(id
),\n KEY Attachments2
(TransactionId
),\n KEY Attachments3
(Parent
,TransactionId
)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8
Unfortunately with the upgrade, the new database was written over the
old one (as adviced by the manual) so I don’t really have the original
database.On 1/12/2010 7:17 μμ, Kevin Falcone wrote:
On Wed, Dec 01, 2010 at 04:25:00PM +0200, Kiriaki Konstantinidou wrote:
Hi.
After I migrated my installation from rt 3.4.1 to rt 3.8.8, Greek
characters don’t appear correctly. New records in Greek are OK. Only
the old records have this problem.
I use Mysql 5.0.27 with innoDB backend with collation
utf8_general_ci (default Mysql and for the rt database).
During the migration I didn’t change the mysql version or the
collation. For the upgrade I followed the instructions in README and
UPGRADING.mysql.
Please provide ‘show create table Attachments’
on the old and new databases.
-kevin
If I recall well even in rt 3.4.1 I had a problem reading greek
characters from phpMyAdmin GUI while the rt GUI was displaying them
correctly. Now rt displays correctly only the new records.
I can’t find anything in the net. Any help would be very much appreciated.
Thank you,
Kiriaki Konstantinidou
kiriaki.vcf (481 Bytes)