TOraSession.Options.ConvertEOL adding extra space to CHAR fields

[jdorlon]

Hello,

When I have TOraSession.Options.ConvertEOL = true, and I select from the table below using a TSmartQuery, the result dataset has extra spaces in the result.

I think that this option should not have an effect here. Is that right? It creates a problem when I want to re-insert the data, because then there are 3 characters worth of data when there should only be 2. I am aware of workarounds but this seems like a bug.

Thanks,

John

Code: Select all

CREATE TABLE AST_ADR_REGEL
(
NL CHAR(2 BYTE) NOT NULL,
LOG_MAND CHAR(2 BYTE) NOT NULL
);

Insert into AST_ADR_REGEL
(NL, LOG_MAND)
Values
('15', '01');
commit;

[AlexP]

Hello,

Thank you for the information. We have reproduced the problem and will try to fix it as soon as possible

[jdorlon]

Hello,

I am on version 9.4.16 now and the problem still exists. Will you please fix it in the next release? A different customer has shown me an easier way to reproduce the problem is just to do a "select 'xxxxx' from dual" and there will be blank spaces at the end of it. The number of spaces = Trunc((length of data) / 2).

Thanks,

John

[AlexP]

This problem is not yet fixed.