What is the character limit per array column cell?

Regarding question 1.

I’m not sure if someone has ever went over this limit, but I assume it will cut off at the 1 million-th character.

Regarding question 2, can you go into more details about what you’re trying to do, specifically about your data structure?