JDBC: Converting Clobs to Strings doesn't show \n line returns

I am connecting to a 4D (fourth dimension brand) database with its crappy jdbc driver.

I have a CLOB on the database and when I fetch it either through getString开发者_如何学C or getClob, I don't get line returns, everything seems to come in one line.

But, if I do do a select on NetBeans database explorer and I copy and paste the value on the editor, It DOES pickup up the \n.

I have noticed that instead of \n\ I am getting character 13

Anybody know why these \n line returns are not coming as they should?

I am using windows 7 64 bit

Pablo

In Windows, the line terminator is \r, under Linux it's \n. Whenever files are exchanged between different systems, great confusion arises.

If you're seeing the wrong kind of line terminator, you'll want to convert those strings. Problem solved.