On Thu, Mar 12, 2009 at 7:27 AM, Paul J Stevens <p...@nfg.nl> wrote:
> Aleksander Kamenik wrote:
>> Simon wrote:
>>
>>> I have read various things, but it would be good to get the correct
>>> thing todo here please?
>>
>> First check your database settings. Default collation was latin/swedish
>> for mysql I think. Compare your old and new my.cnf files. Check the
>> client as well as the mysql subsections. Has anything changed? Obviously
>> they have to match.
>
> If you can run both mysql and dbmail with utf8 encoding.
>
>>
>> IIRC you can use show create table_name to see the encoding/collation.
>
> Correct.
>
>> Also, you're not using mysql 5.1 by any chance. It's not recommended
>> yet. Stick to 5.0.
>
> Actually, 5.1.32 was released last week which was pitched as production
> quality. Personally, I'll stick with Monty's advice: avoid 5.1:
>
>
> http://monty-says.blogspot.com/2008/11/oops-we-did-it-again-mysql-51-released.html\
I think i need to change the encoding/collation:
show create table dbmail_messageblks;
+--------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Table | Create Table
|
+--------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| dbmail_messageblks | CREATE TABLE `dbmail_messageblks` (
`messageblk_idnr` bigint(21) NOT NULL auto_increment,
`physmessage_id` bigint(21) NOT NULL default '0',
`messageblk` longblob NOT NULL,
`blocksize` bigint(21) NOT NULL default '0',
`is_header` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`messageblk_idnr`),
KEY `physmessage_id_index` (`physmessage_id`),
KEY `physmessage_id_is_header_index` (`physmessage_id`,`is_header`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 |
+--------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)
If this is so... can someone post the steps here please?
_______________________________________________
DBmail mailing list
DBmail@dbmail.org
http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
