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.
--
________________________________________________________________
Paul J Stevens pjstevns @ gmail, twitter, skype, linkedin
* Premium Hosting Services and Web Application Consultancy *
www.nfg.nl/[email protected]/+31.85.877.99.97
________________________________________________________________
_______________________________________________
DBmail mailing list
[email protected]
http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
