Text field limit: 2GB, or 10,000,000 characters?

[Northbay]

Looking for text field limit for FileMaker 14, and this is what I got:

2GB, or "< 10,000,000 characters per field per repetition (limited by available memory)".

This is where I got confused. What does it mean "10,000,000 characters per field per repetition"? It definitely not is the length of the full text, I believe.

[Kris M]

Text fields can have up to 32,000 repetitions.

Each repetition can hold a maximum of 10,000,000 chars.

 

[comment]

1 hour ago, Northbay said:

Looking for text field limit for FileMaker 14, and this is what I got:

2GB, or "< 10,000,000 characters per field per repetition (limited by available memory)".

Where are you quoting this from? The official source to go to is here -  and it does not say "2GB".

[Northbay]

Thanks for the explanation, Kris M.

Hi comment, yes, it's not a official source because I can't find any. The link is here. By the way, do you know any info about the maximum of a text field, i.e. 2GB or something else?

 

Edited March 7, 2016 by Northbay

[comment]

Did you not notice the link in my previous post?

18 minutes ago, comment said:

The official source to go to is here

 

[Northbay]

Yes, that's the first one I searched. I just still have no idea how many a text field will hold finally because I can't find any explanation for "10,000,000 characters per field per repetition" before Krim M give one.

Edited March 7, 2016 by Northbay

[comment]

2 minutes ago, Northbay said:

I can't find any explanation for "10,000,000 characters per field per repetition"

I agree it is not well formulated. It seems like they wanted to say "10,000,000 characters per repetition". Which in practical terms (assuming you are not using repeating fields) would translate to "10,000,000 characters per field".

[Northbay]

22 minutes ago, comment said:

I agree it is not well formulated. It seems like they wanted to say "10,000,000 characters per repetition". Which in practical terms (assuming you are not using repeating fields) would translate to "10,000,000 characters per field".

comment, based on Krim M's explanation, may I say the maximum a text field can hold is "10,000,000 characters x 32,000" ?

[Wim Decorte]

Not really, because each repetition in a field is in essence a different field.

[Northbay]

19 minutes ago, Wim Decorte said:

Not really, because each repetition in a field is in essence a different field.

So that mean the maximum limit for a single text field is just 10,000,000 characters, right?

[comment]

17 minutes ago, Wim Decorte said:

each repetition in a field is in essence a different field.

That depends on the purpose. For example, for the purpose of finding (and hence for the purpose of indexing), all repetitions of a field are in essence a single field.

 

49 minutes ago, Northbay said:

based on Krim M's explanation, may I say the maximum a text field can hold is "10,000,000 characters x 32,000" ?

You may say whatever you wish, but the only authoritative source we have is FMI's tech specs. What exactly is the issue you are trying to solve here?

[Northbay]

35 minutes ago, comment said:

That depends on the purpose. For example, for the purpose of finding (and hence for the purpose of indexing), all repetitions of a field are in essence a single field.

 

You may say whatever you wish, but the only authoritative source we have is FMI's tech specs. What exactly is the issue you are trying to solve here?

I want to create a global text field to put tech journals. It's supposed to be big. Seems OK for now, but I'm just worried about sometime in the future ...

[comment]

1 hour ago, Northbay said:

I want to create a global text field to put tech journals.

1. Why would you want to use a global field for this?

2. Keep in mind that the more structured your data is (e.g. divided into publications, volumes, articles) the more control you will have. For dumping data into a black hole, you might be better off using a text file.

[bruceR]

What do you mean, "a global text field to put tech journals."?

Recognize that a global field is an evaporating field.

Is this a multi-user system?