Thanks Razzak and Karen. It looks like I will use a text data type since we
will keep it under 250 characters.
I like to keep my databases as small as possible.
Dan Goldberg
-----Original Message-----
From: A. Razzak Memon
Sent: Wednesday, October 12, 2011 8:16 AM
To: RBASE-L Mailing List
Subject: [RBASE-L] - Re: note fields
At 10:51 AM 10/12/2011, Dan Goldberg wrote:
>I am looking for your opinion on data types.
>
>Are note data type columns the best to use for long text fields?
>
>I have used them in the past but now there are other data types
>that might be better to use.
Dan,
A few suggestions:
01. If you know the range of your text (1 - 1500), and there is no
plan to expand, use TEXT (value) data type.
02. If going beyond 1,500 and not exceeding 4,092 characters, use
NOTE fields.
03. If going beyond 4,092 characters and having the flexibility of
variable characters and formatted text data, use VARCHAR data
type.
Notes and Tips:
TEXT Data Type:
- Holds alphanumeric data
- The default length is eight characters; the maximum is 1,500 characters
- Unlike NOTE columns, you set the maximum length of a TEXT column
- R:BASE reserves a minimum of four bytes of internal storage space
- Indexes and constraints are allowed on TEXT data types
NOTE Data Type:
- Holds variable length text of up to 4,092 characters
- NOTE data type columns cannot be used in an expression
- The actual length of each NOTE entry is determined by the data contained
in the column; you do not set a length
- R:BASE reserves a minimum of four bytes of internal storage space
- The NOTE data type now supports a size (n). The NOTE data type will
truncate at (n) characters and give a warning
- Indexes and constraints are allowed on NOTE data types
- No length is needed
VARCHAR Data Type:
- Holds alphanumeric data
- No length is needed
Also, refer to R:BASE in-line Help for String Manipulation Functions
and restrictions, if any.
Hope that helps!
Very Best R:egards,
Razzak.
--- RBASE-L
================================================
TO POST A MESSAGE TO ALL MEMBERS:
Send a plain text email to [email protected]
(Don't use any of these words as your Subject:
INTRO, SUBSCRIBE, UNSUBSCRIBE, SEARCH,
REMOVE, SUSPEND, RESUME, DIGEST, RESEND, HELP)
================================================
TO SEE MESSAGE POSTING GUIDELINES:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: INTRO
================================================
TO UNSUBSCRIBE:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: UNSUBSCRIBE
================================================
TO SEARCH ARCHIVES:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: SEARCH-n
(where n is the number of days). In the message body,
place any
text to search for.
================================================
