Ted Roche wrote:
> On 1/17/07, Dave Crozier <[EMAIL PROTECTED]> wrote:
>
>> However, always remember though that there is no such thing as a "Numeric"
>> index as all the data you index on is converted to a character expression
>> before it is indexed. Hence you can seek on a character key even though you
>> created the index as a "numerical index"
>>
>>
>
> I know that was true back in the FoxBase days, but aren't integer
> indexes smaller than other types because they are packing integers
> rather than converting them to strings?
>
>
Yes, each integer field is only 4 bytes.
*Visual FoxPro Field Types*
Field type Description Size Range
Character (Binary) </html/9d346afb-3b45-4178-85e2-68298ba4507f.htm>
Any *Character* data that you do not want translated across code pages
For example, user passwords stored in a table and used in different
countries or regions.
1 byte per character to 254
Any characters
Double </html/c3a10d85-d38a-4bee-b072-6f88d0a0775e.htm>
A double-precision floating-point number
For example, scientific data requiring a high degree of precision.
8 bytes
+/-4.94065645841247E-324 to +/-8.9884656743115E307
Float </html/fe695288-5d41-4425-84a2-0d0f40a40cb7.htm>
Same as *Numeric*
8 bytes in memory; 1 to 20 bytes in table
- .9999999999E+19 to .9999999999E+20
General </html/12244287-5c07-4f00-b2ae-c734b2a4becd.htm>
Reference to an OLE object
For example, a Microsoft Excel worksheet.
4 bytes in table
Limited by available memory.
Integer </html/e2e6eeaf-b170-4a8c-b826-c5127938d8d6.htm>
*Numeric* value with no decimals
For example, a line number in an order.
4 bytes
-2147483647 to 2147483647
Integer (Autoinc) </html/e2e6eeaf-b170-4a8c-b826-c5127938d8d6.htm>
Same as *Integer* but also an automatically incrementing value. Read-only.
4 bytes
Value controlled by autoincrement Next and Step values.
Memo </html/89b18a82-1168-4f2f-a5ce-20784b94579a.htm>
Alphanumeric text of indeterminate length or reference to a block of data
For example, notes about a phone call in a phone log.
4 bytes in table
Limited by available memory.
Memo (Binary) </html/89b18a82-1168-4f2f-a5ce-20784b94579a.htm>
Same as *Memo* except that memo field data does not change across code pages
For example, a login script used in different countries or regions.
4 bytes in table
Limited by available memory.
Varchar </html/ecece0aa-2f1b-4135-8429-8a173c9e835e.htm>
Alphanumeric text.
*Varchar* is similar to *Character* except values in *Varchar* fields do
not include padding with additional spaces. The length of the contained
value is stored internally.
1 byte per character up
_______________________________________________
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
** 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.
