Print Thread
CLOB and chr(10)
#64453 02/23/23 10:32 AM
Joined: Nov 2016
Posts: 100
F
fabrice Online Content OP
Member
OP Online Content
Member
F
Joined: Nov 2016
Posts: 100
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 by fabrice; 02/23/23 12:33 PM.
Re: CLOB and chr(10)
fabrice #64459 02/24/23 09:05 AM
Joined: Aug 1999
Posts: 22,220
Member
Offline
Member
Joined: Aug 1999
Posts: 22,220
It seems that the Large Data Editor does not comply to the CR/LF preference. We'll fix it.


Marco Kalter
Allround Automations
Re: CLOB and chr(10)
fabrice #64463 02/24/23 10:46 AM
Joined: Nov 2016
Posts: 100
F
fabrice Online Content OP
Member
OP Online Content
Member
F
Joined: Nov 2016
Posts: 100
thanks


Moderated by  support 

Link Copied to Clipboard
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Release build 20200307)
Responsive Width:

PHP: 7.1.33 Page Time: 0.073s Queries: 14 (0.033s) Memory: 2.5042 MB (Peak: 3.0428 MB) Data Comp: Off Server Time: 2024-05-17 07:41:57 UTC
Valid HTML 5 and Valid CSS