This outstanding information that I have not been able to find elsewhere!!!!!The fact that there are 3 contact databases on an android.
Actually, there is a 4th type that I forgot to mention. "Facebook contacts" are synchronized with Facebook. I use Facebook, but not for contact management. It seems to be a nightmare for creating duplicate contacts, and I don't want them to have my valuable contact information.
Does the calendar also store the same number of calendars (google, corporate and phone only)?
The method you list here with hotmail is one method I am considering in order to sync a local outlook PST file to a future 4.0 android phone in addition to syncing a corporate exchange account. But since this hotmail method uses the same database for storage that my direct exchange sync would, perhaps that would not work for me?
With the built-in (I believe stock Android) calendar app on my LG Optimus S phone, I can't conveniently VIEW different calendar accounts SEPARATELY by selecting a particular calendar. But the calendar events don't get merged in the phone's database or on Outlook, or on Hotmail. If I really want to view different calendar accounts separately on my phone, I can do so by going into the sync settings and choosing which of my several calendars to sync and view (as is described in my original post).
To my knowledge (at least with my stock calendar app) there is no equivalent to "phone-only contacts". I.e. No "phone-only calendar" events.
You can have multiple Gmail, Hotmail, and Exchange accounts on Outlook and on your phone, each with its own email Inbox, Calendar, and Contacts folders. On Outlook you can easily view them separately by clicking on each account. On Android (at least with my stock Email, Calendar & Contacts apps), my email Inboxes can easily be separately clicked-upon and viewed separately (or viewed merged), but the Calendars & Contacts for all of my accounts are DISPLAYED in a merged view. However, they are only DISPLAYED in a merged view. They are not actually merged in the phone's database or on the servers. Hotmail and Exchange may use the same database format, but they don't necessarily use the same database. The bottom line is that you don't have to worry about your contacts or calendar data getting merged between Hotmail, Exchange, Gmail, etc. Whether or not you can CONVENIENTLY (one-click) view your contacts and calendars SEPARATELY on your phone is a different issue and probably depends on your phone's contacts and calendar apps. (I imagine that there are contacts and calendar apps out there that let you CONVENIENTLY, SEPARATELY
VIEW your different contacts and calendar accounts with a single click.
It may be worth repeating that wtih Android, at any time you can choose whether or not to sync and/or view the contacts or calendar from a particular account.