 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Outlook / Contacts / December 2003Contacts Schema
Does anybody have a complete schema for Exchange 2000 Contacts? I see all the fields in the SDK docs and by using the "F2" key in MS VB6 but I can't find any reference to the length for each of the string fields. I want to create a SQL table to export the contacts to but I don't know if all of the SQL fields have to be varchar 255. An MS-SQL create table script would be perfect but any other schema releated information will be appreciated. Thanks... Jeff String fields can be much longer than 255 characters and for Body you'd have to allow for a virtually unlimited field length since a Body can exceed 65535 characters easily. -- Ken Slovak [MVP - Outlook] http://www.slovaktech.com Author: Absolute Beginners Guide to Microsoft Office Outlook 2003 Reminder Manager, Extended Reminders, Attachment Options http://www.slovaktech.com/products.htm > Does anybody have a complete schema for Exchange 2000 Contacts? > [quoted text clipped - 9 lines] > > Jeff Yes, a string can be much larger than 255 but my goal is a MS-SQL table Yes, a string can be much larger than 255 but my goal is a MS-SQL table (schema) to properly hold the contacts database. It doesn't seem too efficient to have every SQL field of type "text" so I looked at the contacts GUI form and it seems that most of the string fields don't allow you to type more than 255 characters except the "body" field which I did make a text field. The Exchange SDK docs. don't really provide very good detail in this area and I feel that 110 fields of varchar(255) is also very crude but seems necessary. Any further thoughts on this ? Thanks, Jeff > String fields can be much longer than 255 characters and for Body > you'd have to allow for a virtually unlimited field length since a [quoted text clipped - 22 lines] > > > > Jeff I haven't seen any schema like that, although it might exist somewhere I suppose. If you use varchar(255) you would just have to truncate any fields that are longer. You also might want to account for possible unicode fields if applicable, depending on the user base and the charsets they use. -- Ken Slovak [MVP - Outlook] http://www.slovaktech.com Author: Absolute Beginners Guide to Microsoft Office Outlook 2003 Reminder Manager, Extended Reminders, Attachment Options http://www.slovaktech.com/products.htm > Yes, a string can be much larger than 255 but my goal is a MS-SQL > table Yes, a string can be much larger than 255 but my goal is a [quoted text clipped - 13 lines] > > Jeff |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.