> Unlike VFP, for numeric fields, the field's size (ie the maximum > number allowed in the field) is dictated only by the type you choose, > ie, tinyint, int, etc.. > > TINYINT cannot except any value > 255 in it's field for UNISGNED and > 127 for SIGNED. > > There's no concept of # of digits it can hold. I find this a bit > confusing honestly, and prefer to think in VFP terms, but maybe > that's just my habits again..
Integer fields work the same in MySQL and VFP. VFP supports only 32-bit signed integers, whereas MySQL supports different sizes and signed/unsigned. MySQL also supports a numeric/decimal type that's equivelent in function and definition to VFP's "numeric" field. In both MySQL and VFP, integer types are preferred for storage/performance versus numeric fields, unless fractions are required. -- Derek _______________________________________________ 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.
