CLOB and chr(10)

fabrice

Member³
Hello,
when i insert string + chr(10) in a CLOB column, reading this column in pl/sql dev, i see in hex tab ODOA, so chr(13) || chr(10).
Is there a change in the database or in pl/sql dev to explain that?

If i try to do INSTR with chr(13) , i find 0.

Option read LF as CR/LF is uncheck.
Database and client are on windwos OS.

Thanks
 
Last edited:
Back
Top