D&D (2024) One D&D Cleric and Species playtest survey is live.

aco175

Legend
So, I discovered something interesting. You can string any number of words together with hyphens in the “additional comments” boxes and they’ll all get counted as one word. I think if you were to use this to type a several-hundred-all-hyphenated-word-response you’d probably just get your response thrown out without it ever being read, but it might be useful if you’ve hit the 200-word limit and just need to squeeze an extra couple of words in there.
I sometimes wonder if this site needs a 200 word limit on some of the posts. I find myself skimming a lot on longer posts. It is a bit rude and a disservice to the poster, but come on man. At least some have a TLDR.
 

log in or register to remove this ad

Charlaquin

Goblin Queen (She/Her/Hers)
Bypassing form validation on order to submit a longer entry does not guarantee that the database field it is probably getting written to won't simply limit the IMSERT to the number of characters the form tried to benforce. There is a good chance the excess goes away or even that it simply fails to store the entire text box depending on how the code is written to at re it when you click next
It’s not limited by characters though, it’s limited by words.
 


Charlaquin

Goblin Queen (She/Her/Hers)
That doesn't mean that there isn't a db field with a character limit. Web ui survey crunching & database administrators are often very different groups of folks :D
I guess so, but then wouldn’t some responses be at risk of getting cut off if a lot of their 200 words were long ones and/or they used a whole lot of punctuation?
 

Oofta

Legend
I sometimes wonder if this site needs a 200 word limit on some of the posts. I find myself skimming a lot on longer posts. It is a bit rude and a disservice to the poster, but come on man. At least some have a TLDR.
I-don't-know-why-you-would-say-that, long-posts-are-perfectly-fine. It's-not-like-people-ramble-on-and-on, we-have-important-things-to-say! ;)

Really-wish-I-had-more-to-say-on-this-but-I-haven't-had-time-to-do-the-survey-yet.
 

tetrasodium

Legend
Supporter
Epic
I guess so, but then wouldn’t some responses be at risk of getting cut off if a lot of their 200 words were long ones and/or they used a whole lot of punctuation?
Depends on how it's done. I don't know the limits on the form but lets say it's a nice round 250 words on the form for purpose of discussion. Imagine this process:
  • Alice from the survey crunching research group tells their contact person Bob at their new client that survey responses shouldn't be more than about a page.
  • Bob tells Cindy in webdev that they need a form with these questions from Dave's group but the survey team says to make sure no answers are more than about a page max.
  • Cindy starts working on building a form after firing off a ticket to Eddie in serverOps or whatever saying that she needs a database named survey _xxx with the following fields.
    • Eddie's team kicks it back saying they need more info about the text fields they need to create
    • Cindy consults google to see that a page is about 250 words &fires it back saying no more than a page or 250 words.
    • Eddie's team sighs because they told Cindy they need a number of characters not words or pages. They too consult google & see that a page is about 1800 characters & that a word is usually considered 5 characters. They look at Cindy's ticket where it says "no more than A or B" so they set the limit to 1250 characters because you get that from 250*5
  • Frank uses the eventual form to submit some stuff but is 75 words over, many of the first 250 words he used are more than 5 characters too so his average is already like 6 or 7 characters per word. He uses the validation defeat mentioned to add 75 more but only the first 15o words even get into the db so the rest never even had a chance.
 

200 words is nowhere near the actual limit if they're using some MySQL-based db, the character limit is probably 65535 characters if it's a text column. But no one wants to read something that's 65535 characters long when there's so many other things to read.
 

Lojaan

Hero
I think "ancestry" will never be an option. The purpose of "species" or "subtype" and the like are to be purely * biological* descriptions. Seperate from background, culture, history etc... Ancestry has all that stuff very much mixed in so is not applicable.

Species was jarring when I first heard it but I'm used to it now. Subtype is pretty decent because it is clearly a game term.
 

tetrasodium

Legend
Supporter
Epic
200 words is nowhere near the actual limit if they're using some MySQL-based db, the character limit is probably 65535 characters if it's a text column. But no one wants to read something that's 65535 characters long when there's so many other things to read.
That doesn't mean that nobody uses things like varchar(max). There are good reasons for doing so.
 


Remove ads

Top