When there are special characters, like newline and end-of-line, stored in a column, it is unable to see them directly. Function dump() is the best tool in this situation:
select dump(column_name) from ...
If there is a 0 returned, it hits NULL control character (ASCII character 0, eg chr(0) ).
