On Fri, January 23, 2009 4:48 pm, Ed Leafe wrote: > On Jan 22, 2009, at 1:47 PM, MB Software Solutions General Account > wrote: > > >> Personally, I'd rather not use txt_, dat, etc. in my field names, >> but just c (for character), d (for date), t (for date/time), n (for >> numeric), etc. > > As a former Hungarian Notation user, I've since come to see the > shortcomings of such systems. One of the main problems is that your > abbreviations are not universal: is is 'c'haracter, 't'ext, 'v'archar, > 'b'inary text, or what? > > > Different database systems have different datatypes, and some let you > define your own custom data types. What do you do then? > > I now use a plain, descriptive column name, and rely on the DDL if a > dev needs to know the data type.
I'd like ammend my answer (after reading yours) to use the system I described, and if the dev needs to get a clarification on what kind of character field it is (char, text, varchar, binary), then s/he can rely on the DDL for that clarification. ;-) _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[email protected] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
