Text Data Types

Small Text

Saves up to 255 characters of a single line of text. You may use this data type to save titles, names, short descriptions, web links, emails or phone numbers.

Long Text

Saves up to 256 KB characters of multi line text, You may use this type to save long descriptions or notes where the text may longer than the limit of a small text area or must be displayed in multiple lines. You are recommended to prefere "small text" data type unless you plan to enter text longer than 255 chars.

Avoid creating a text field for saving only numerical values else they will not be sorted correctly in tabular views. You may select "integer" or "decimal" data type to save numerics.

General Properties

Some features given below are only available for small text fields.

Default Value: Sets the default value inserted automatically whenever you start creating a new record.

Text Alignment: Sets the horizontal alignment of the text content.

Duplicate Data: Select whether two distinct records of this catalog may have the same data in this field. If you disallow duplicates, SpeedBase will show a warning message and refuse to save the current record if duplicates are found. If you select "Allow w. Warning" instead, a duplicate warning icon will be displayed but the user will still be allowed to save the record.

Force Case: If a case rule is selected, SpeedBase will automatically change the case of letters when the user saves the record.

Required: If checked, the user will be required to enter data to this field before the record can be saved.

Text Format

Advanced Properties

Encrypt Data: If checked, data entered into this field will be encrypted. You must have enabled the encryption feature from preferences window before you can activate it on field properties window.

Encryption setting can only be determined during creation of a new field. Once the field was created, this setting cannot be changed. If you want to turn on encryption for an existing field, the recommended way to do it is:
- Enable encryption from preferences window if you didn't do it already.
- Export all data on that field for all records to file.
- Create another copy of that field and make sure to activate the encryption option.
- Import the previously exported data to the new field.
- Delete the older version of the field.

For multiuser licenses, if you want to make sure to remove all traces of un-encrypted version of data:
- Execute "optimize/repair" database from the "maintenance" tab of the connection window.
- Move all backup copies of your database to a more secure location as they still contain the unencrypted version of the data.

If you want to turn off encryption for an existing field, create an unencrypted version of the field and then follow the same export/import steps given above.

Create Index: Creating an index may improve performance for accessing/searching records but also may slow down creating/importing/deleting records. Not available for long text fields. You are recommended to leave this box as it is unless you are a database specialist.

Online Help Home Page   ::   SpeedBase Software Home Page