I am currently using Posit Connect to host Shiny apps that pull data stored in Postgres tables. I noticed recently that Shiny apps hosted on Posit Connect only seems to display the first 255 characters of textInputArea(). It does save all characters to the database, and it is viewable when running the Shiny app locally. The data type in Postgres is text.
Is there a Posit Connect setting that I am not seeing that may be causing this? A colleague mentioned a work around is to change the type in Postgres to varchar, which is fine, but I was curious to why it would work locally but not on Posit Connect. Let me know if there is any additional information I can provide.
Interesting. Do you have an example app you can share? Is the behavior consistent across browsers? Could you share the versions of R / Shiny / Connect / Postgres that you're seeing this behavior with?
It appears to happen in both Microsoft Edge and Google Chrome (only two browsers that are installed). The areaTextInput() shows all the text when it is entered as an input, but when the details are pulled from the server, it only displays the first ~256 characters. The only other difference I can think of between running it locally vs Posit Connect is that locally we run everything on Windows vs Linux for Posit Connect. I'm not sure if that would cause the issue though. I'll see if I can replicate the issue on a non-Postgres database.