I am trying to count the number of characters in a string, but every value I return is '100'. The values are discussion question responses in Blackboard. Here is the query I am using:
SELECT char_length(dse.event_text)
FROM discussion_stream_event dse
This returns a '100' for every line even though the responses can range from a dozen characters to more than a thousand. The data type for dse.event_text is character varying, but even when I cast it as text the value returned is still 100.
Any ideas how I might count these characters? Thank you!