| Name: | CHAR VARYING | Family: | Datatype |
|---|---|---|---|
| Ranges: | 1 character to 256MB | Maps To: | VARCHAR |
| Description: | Large amounts of text data | ||
The CHAR VARYING type is mapped internally to the VARCHAR datatype. A length is required. If you set the maximum length to a value over 32,767 characters, the limit is ignored and defaults to 256 MB. VARCHAR data is stored in file 4.
Holds alphanumeric data. When editing in a form or with the BROWSE or EDIT command there is an automatic mapping between the lineend character (by default ^) and the CTRL-ENTER (Hard Line Feed) "character". This automatic mapping is done when the field is Zoomed. A field can be "zoomed" by default by using the Shift-F2 key combination. This allows the VARCHAR data to be unloaded without extra line feeds. It also allows for easier data entry.