CLOB Editor automatically adds end-of-line?

[Martin T.]

It seems to that that the Text mode of the large data editor (e.g. for CLOBs) automatically adds end-of-line characters to any modified text.

Steps to reproduce:

- Set a CLOB value to any text no containin CR/LF
- Edit that CLOB value
- Reselect the CLOB value

You will see CR/LF in the Hex View, though you have not entered them.

Is this a known / desired behavior?

I am running 7.03.1123 with Oracle 10g and Unicode support.

Thanks,

Martin

 

[Marco Kalter]

You will indeed see CR/LF pairs in PL/SQL Developer. On the server only LF characters are used as end-of-line characters.

 

[Martin T.]

Marco,

I understand that there is is automatic conversion of CR/LF and LF.

However, is it actually desired behaviour that the editor actually adds a line-break (regardless of CR/LF or LF) if no line-break was entered?

This is at least different to the grid editor for regular varchar2 fields.

So, if you edit a varchar2 field in the grid, no end-of line is added. If you edit the same field in the editor text tab, a line-feed will automatically added when you click "Ok".

Martin

 

[Marco Kalter]

However, is it actually desired behaviour that the editor actually adds a line-break (regardless of CR/LF or LF) if no line-break was entered?

No, this should never happen. If you have a reproducible case for this, please let me know.

 

[Martin T.]

Marco,

I am able to reproduce the problem with the following steps.

1. create an new table with only one VARCHAR2(100) field
2. Add one record. Set the field value to 'test'. Use the grid, not the editor for this.
3. Select the same dataset again. You will see in the HexViewer of the editor, that no CR/LF is present.
4. Perform any text change without adding a new line in the text editor. Post the data. Reselect.
5. A trailing CR/LF can be seen in the HexViewer of the Editor. Also, it is actually present in the database.

Again, I am running an Oracle 10g Unicode database.

Are you able to reproduce that way? If not, what additional information do you might need?

Thank you,

Martin