ok thx for your help
On Wed, 02 Jan 2013 11:10:59 +0100, Paul J Stevens <[email protected]> wrote:
On 01/01/2013 08:11 PM, Harald Leithner wrote:
@Harald thx
@Paul ok most of my tables are utf8
Great. Remember, this only matters for 8bit data stored in the database.
7bit clean data (ascii) is not an issue.
Those tables are still latin:
dbmail_envelope - is a cache table or? (644k rows)
content should be 7bit clean, so encoding doesn't matter
dbmail_mailboxes - could be a problem but it seams that imap encodes non
latin characters: &APw- is Ü (1,5k rows)
same here. The encoding is a modified version UTF7. All 7bit clean.
dbmail_messages - only integer and md5 hash but 700k rows could take
some time but should not matter
same.
dbmail_physmessage - only integer and datetime with 635k rows but should
not matter
same
dbmail_referencesfield - cache table or? looks like real message ids so
should not matter
same
dbmail_users - user table has a password field that could make problems.
Only if you store passwords as plaintext. Encrypted data is stored as a
7bit clean hash.
So should I convert any of these tables or should I leave them?
No immediate reason to convert, I'd say.
--
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
