Text and Rich Text fields limitations

[Sam Stamport]

I've not been able to find the limitations of the text field and the rich text field in terms of the maximum number of characters that can be entered into each. Surely there is a limitation with text fields holding less than rich text fields?

Where is the documentation that details this?

Thanks.

[Bill Crews]

If it's not in Help, and I doubt it is, you answer is most likely found here in the forum, not as a link to documentation. If you or anyone else finds the answer by trying, I hope the answer is related to the forum.

--
You received this message because you are subscribed to the Google Groups "mementodatabase" group.
To unsubscribe from this group and stop receiving emails from it, send an email to mementodataba...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/mementodatabase/fe9aa0ee-de7c-4f67-80f7-b3d47c9c5826n%40googlegroups.com.

[Beth Dixon]

What is the purpose that you wish to use the text field and/or rich text field for??  

Perhaps if members of the forum understood your needs they could advise of any limitations they have experienced.

Personally, I don't bother with the rich text field at all.  I don't like how it displays the fonts.

- Beth

--

[Sam Stamport]

No offense, but I don't see how the purpose of using these fields is relevant. Is there some hidden code in the database that adjusts the maximum number for each type of field once it somehow figures out why I'm using these fields?

I simply want to know the maximum number of characters can fit into each field.

Maybe I'm too much old school, but I'm amazed that this is not in the documentation provided by Memento.  All sorts of unexpected behavior could happen if the max is exceeded. This also is not documented. 

[Elizabeth Dixon]

Ummm, nope.  No hidden code.  But if you google text field maximum characters you will understand that how one wishes to use the field is relevant.

https://www.google.com/search?q=text+field+character+length&oq=text+field+character+length+&gs_lcrp=EgZjaHJvbWUyBggAEEUYOdIBCTExNTcwajBqOagCALACAA&client=ms-android-samsung-ss&sourceid=chrome-mobile&ie=UTF-8

https://support.microsoft.com/en-au/office/data-types-for-access-desktop-databases-df2b83ba-cef6-436d-b679-3418f622e482

Good luck, maybe someone else has an answer.

Beth 

To view this discussion on the web visit https://groups.google.com/d/msgid/mementodatabase/56bcf9ee-04ef-45ac-9dae-a71a86441d08n%40googlegroups.com.

[Bill Crews]

Historically, there has been critically little documentation for Memento, and this is why I, as a user, developed the wiki based on what I had learned, often by trying things and seeing what happened. I never tried to fill up a text field or a rich text field to see what happens and at what point it happens. It would not be very hard to do with a script. Maybe I'll do it some time.

The sizes of many things, including field values, can be found in JavaScript documentation. The number for JavaScript strings, which hold text field values, appears to be 2**53 - 1 (2 to the 53rd power minus 1). You could try the JavaScript docs...

https://developer.mozilla.org/en-US/docs/Web/JavaScript

To view this discussion on the web visit https://groups.google.com/d/msgid/mementodatabase/56bcf9ee-04ef-45ac-9dae-a71a86441d08n%40googlegroups.com.

[Bill Crews]

My message is not to say the Java code of the Memento app or of its components (like SQLite) themselves might have some restriction greater than JavaScript.