upgraded to last svn 2103, and... wow :|
and now? database+tables+columns are all set to utf8 and utf8_general_ci
May 4 20:59:44 lira dbmail/imap4d[2665]:
dbmysql.c,db_mysql_check_collations: collation mismatch, your MySQL
configuration specifies a different charset than the data currently in your
DBMail database.
----- Original Message -----
From: "Jorge Bastos" <[EMAIL PROTECTED]>
To: "DBMail mailinglist" <[email protected]>
Sent: Thursday, May 04, 2006 7:41 PM
Subject: Fw: Fw: [Dbmail] Charset and Collation
Any sugestions Paul, or somebody else from dbmail? :PP
Jorge
----- Original Message -----
From: "Jorge Bastos" <[EMAIL PROTECTED]>
To: "DBMail mailinglist" <[email protected]>
Sent: Thursday, May 04, 2006 11:27 AM
Subject: Re: Fw: [Dbmail] Charset and Collation
Well... not really, i changed table by table, i know that the instruction
below alters everything, but i only saw that after i change.
----- Original Message -----
From: "Paul J Stevens" <[EMAIL PROTECTED]>
To: "DBMail mailinglist" <[email protected]>
Sent: Thursday, May 04, 2006 11:02 AM
Subject: Re: Fw: [Dbmail] Charset and Collation
Jorge Bastos wrote:
Can someone tell me something about this?
Jorge
----- Original Message -----
*From:* Jorge Bastos <mailto:[EMAIL PROTECTED]>
*To:* DBMail mailinglist <mailto:[email protected]>
*Sent:* Wednesday, May 03, 2006 12:20 AM
*Subject:* [Dbmail] Charset and Collation
Paul,
I Don't know if this part is you that take care of it but there it
goes...
I don't know if you remember i said something about charset.
So...i have the database set to charset=utf8 and
collation=utf8_general_ci and all tables and their fields set to the
same, before it i had charset=latin1 & collation=latin1_swedish_ci.
So you did:
ALTER TABLE dbmail_messageblks MODIFY messageblk LONGBLOB NOT NULL;
ALTER TABLE dbmail_messageblks MODIFY messageblk LONGTEXT NOT NULL
CHARACTER SET utf8;
as described in the mysql manual section 10.10.2
right?
--
________________________________________________________________
Paul Stevens paul at nfg.nl
NET FACILITIES GROUP GPG/PGP: 1024D/11F8CD31
The Netherlands________________________________http://www.nfg.nl
_______________________________________________
Dbmail mailing list
[email protected]
https://mailman.fastxs.nl/mailman/listinfo/dbmail
_______________________________________________
Dbmail mailing list
[email protected]
https://mailman.fastxs.nl/mailman/listinfo/dbmail
_______________________________________________
Dbmail mailing list
[email protected]
https://mailman.fastxs.nl/mailman/listinfo/dbmail
