Hi,
when I make simple query to data on our Postgres server I become truncated data in return. Field in database is declated as text but query returns data with right truncated 0?
Hi @Karlek
Could you please provide the following details:
-
An example of the SQL query (if applicable), or a description of how the data reaches the problematic state
-
An example of a specific value: what is stored in the database and what is returned as a result
-
Does the issue occur for all rows or only for specific ones?
-
Where exactly is the truncation visible: in the query result, datasource preview, table component, or only at runtime?
-
A screenshot or export of the result showing the truncated value
-
Do the problematic values contain any special characters, line breaks, Unicode, very long text, or null bytes?
Thank you!
This looks more like a null byte issue than a Postgres text limit. I’d check one affected row for \x00 first, because the DB can hold the text while the UI layer stops rendering at the first null. Something like position(E'\000' in your_column) or encode(convert_to(your_column, 'UTF8'), 'escape') should tell you fast. If those come back clean, compare datasource preview vs the table/runtime component, because I’ve seen truncation show up only in the renderer.
1 Like
