Missing line breaks at end of data when reading from database

Question

Hi everyone, I have the following problem: I am reading from an Oracle database via an Input tool with the OCI driver some data that sometimes has a line break at the end of the text. Here is an example taken from the SQL editor (text blackened out, as this is data from a customer):

When I read this into Alteryx I get this:

Might be difficult to see, but there is no line break at the end. However, when I read in the same data with the same SQL statement, but with the ODBC driver instead of OCI, I actually get the line break at the end:

Has anyone ever seen this behaviour or might know what is causing this difference?

benjamin_feuchter · Answer

@geraldo So far we've noticed this only in one column, as this is one that stores text that is based on user input, the other columns in that table do not have CRLFs at the end. The field is indeed a VARCHAR2 4000, however, in the database the CRLF is there, and also when I read the column with an ODBC driver, it's just missing when I use OCI. But I'm not sure this is really (just) a driver issue, because when I create a new table with a VARCHAR2 4000 with LFs at the end, these are also properly read in whether I use OCI or ODBC ...

geraldo · Answer

@benjamin_feuchter

How many columns are you reading?

Is this happening in all?

it may be that it is a varchar field in the database and it is recorded like this in the database