Jim
I do need Varchar, this column use to be Note but our users needed more
space for notes.
Thanks for the info on Indexes
Marc
A basic question I have is whether the "Subjx" column really needs to be
VARCHAR. Could a TEXT or NOTE column could be used. Remember both the
TEXT
and NOTE column can be set up with a maximum size. One of the most
overlooked
syntax options is to define a column as "colname NOTE (300)" where in my
example
you have limited the note columns from 1 to 300 characters. TEXT columns
can be
up to 1500 characters and NOTE columns can be a maximum of 4092
characters. Of
course those data type size are limited by the 32 bit version limit of
4096 and
whatever the 64 bit row limit is.
The following is information on text size limits in indexes
"
Full- and Partial-Text Indexes
Text columns can make effective indexed columns. If the size of the column
that
has a TEXT data type is 200 bytes or less, R:BASE creates a full-text
index. A
--- 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.
================================================
