Column data being cutoff?
I have a query that includes a column of school names, but the query results show only part of the school name which makes subsequent reports hard to use. Is there a way we can force the results to include the entire column value?
Text field truncation can occur in some DB clients when browsing rows like you are seeing, but should not be present if you just select the field.
That is unless the field is truncated in the database. This can be checked by LENGTH(school_name) and seeing if the number is larger than the show text.
Most clients that limit text fields on data display/loading can be configured how they behave.Reply