Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Character vs Memo fields
Message
From
23/07/2008 13:32:04
 
 
To
23/07/2008 13:26:17
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
01333464
Message ID:
01333492
Views:
14
>I have never use varchar. Is it fair to say the primary difference between it and Character type is the absense of padding to the full field width? Does the byte cost vary with the actual contents of the field?
>Does varchar width establish the maxlength of the field contants?

Varchar exists primarily for connecting to back-end databases that support the type. In a VFP table, the field length will still be fixed to the maximum; there's no saving in disk space. The only difference is that VFP handles the trimming automatically.

Tamar
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform