-
Hi friends,
Can you help with my problem, I need to save text of more than 255 characters in my database and also I need to index it to speed up the search time, I can't use Text type field because it can contain 255 characters, hence Memo is the solution - but Memo fields cannot be indexed, so what to do ??
I appreciate your prompt answer,
Thank you in advance,
Wesam
-
You could have multiple 255 records that would contain the data. For example
Table1
Unique Identifier
Memo field
would be equivalent to
Table2
Unique Identifier
Sequence number
text(255)