@Harald thx
@Paul ok most of my tables are utf8
Those tables are still latin:
dbmail_envelope - is a cache table or? (644k rows)
dbmail_mailboxes - could be a problem but it seams that imap encodes non
latin characters: &APw- is Ü (1,5k rows)
dbmail_messages - only integer and md5 hash but 700k rows could take some
time but should not matter
dbmail_physmessage - only integer and datetime with 635k rows but should
not matter
dbmail_referencesfield - cache table or? looks like real message ids so
should not matter
dbmail_users - user table has a password field that could make problems.
So should I convert any of these tables or should I leave them?
thank for you help.
On Tue, 01 Jan 2013 19:38:28 +0100, Paul J Stevens <[email protected]> wrote:
On 01/01/2013 06:17 PM, Harald Leithner wrote:
Hi Thomas,
you are right, the database table character set was latin1_swedish_ci,
after converting it to utf8_general_ci it works fine. Thx
@Paul what should be the correct character set for all mysql tables?
UTF8 is highly advisable. DBMail will try very hard to work with other
encodings but results will very much depend on the consistency of the
setup. That is where MySQL is very broken (or lax, depending on your
point of view).
Because mine are mix... I would convert them to utf8 but I'm not sure if
this is save. Should we correct the mysql update script?
There is no way I know of to safely fix this. Yes, you can do a 'alter
table', but that will *not* change anything in your database. MySQL will
happily work with latin-1 encoded data in a table that is marked as utf8
encoded, and vice versa, etc, etc.
If you run mostly on POP3 or a small user-set, just convert the table
schemas and keep them fingers crossed. People may complain about broken
older messages, but newly inserted data at least will be correct.
Of course doing so, you end up with an inconsistent database but since
MySQL doesn't care about consistency this won't bite you until you try
to migrate to a DBMS that does care. This was a major problem for me
when I switched my main development server from MySQL to PostgreSQL -
data went back to dbmail 1.2 days when encoding wasn't even properly
considered in the codebase.
So: if you can get away with changing everything to UTF8, do so. Else,
at least make sure all encoding settings are consistent.
--
Using Opera's revolutionary e-mail client: http://www.opera.com/mail/
_______________________________________________
DBmail mailing list
[email protected]
http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
