Bug: Letter j breaking text - Allround Automations forums

When I have for example letter "j" in text some strange things happened with text.

[Linked Image]

I cannot immediately reproduce this. What do you see when you click on the cell of the 2nd row and bring it to edit mode (so that the text cursor appears in the cell)? Does the correct value appear?

Hi, I encountered no issue with this query:

Quote

select 'Test message: j' from dual
union
select 'Test message: a' from dual

[Linked Image]

Plyxon info:

Quote

Plyxon
------
Plyxon Version 1.0.0.650 (64 bit)
License: Trial
Expiration Date: 08/05/2024 (20 days left)

Running Time: 0:51:17

ExePath: /opt/plyxon
Documents: /home/stephane/Documents/Plyxon
Resources: /opt/plyxon
Settings: /home/stephane/.config/Plyxon/1.0

Color Theme: Light

System
------
Ubuntu 22.04.4 LTS
Language ID:
Scale: 100%
Resolution: 5760 x 1080
Displays: 3
Display 1: 100% 1920 x 1080
Display 2: 100% 1920 x 1080
Display 3: 100% 1920 x 1080

Oracle
------
Connected as: SMILLIEN@FR01
Server Version: Oracle Database 11g Release 11.2.0.4.0

Library: /opt/oracle/instantclient_21_4/libclntsh.so
Version: 21.4.0.0.0

TNS File: /opt/oracle/tnsnames.ora
Aliases: CA01, CA02, CA05, DCM3, EPH, FR01 ...

NLS_LANG: FRENCH_FRANCE.UTF8

Regards,
Stéphane.

In editor it displays correctly. Problem is only in grid.

My configuration is Ubuntu 23.10 with Polish language and locale.

Quote

Plyxon
------
Plyxon Version 1.0.0.650 (64 bit)
License: [REDACTED]

Running Time: 0:00:32

ExePath: /opt/plyxon
Documents: /home/[REDACTED]/Dokumenty/Plyxon
Resources: /opt/plyxon
Settings: /home/[REDACTED]/.config/Plyxon/1.0

Color Theme: Dark

System
------
Ubuntu 23.10
Language ID:
Scale: 100%
Resolution: 4480 x 1730
Displays: 2
Display 1: 100% 2560 x 1440
Display 2: 100% 1920 x 1080

Oracle
------
Connected as: [REDACTED]
Server Version: Oracle Database 18c Standard Edition 2 Release 18.0.0.0.0

Library: /opt/oracle/instantclient/libclntsh.so
Version: 19.14.0.0.0

TNS File: /[REDACTED]/oracle/tnsnames.ora
Aliases: [REDACTED]

NLS_LANG: POLISH_POLAND.AL32UTF8

When I go into cell in edit mode it displays correctly.
When I only have a focus on this cell it displays incorrectly.

OK, Strange, we use the same release of Plyxon.
I have tested focused / editing / not focused: I have no issue with the displayed data.
BR,
Stéphane.

Originally Posted by Łukasz

When I go into cell in edit mode it displays correctly.
When I only have a focus on this cell it displays incorrectly.

Okay, this indicates a visual problem with the result grid. Can you do one more test with the following query?

Code

select 'Test message: j' from dual
union
select 'Test message: k' from dual
union
select 'Test message: a' from dual

If we know the results of this query we will send you a test version with some extra diagnostics.

For "k" is ok.
[Linked Image]

Polish diacritics letters making this issue is ś, ź, ń.

Quote

select 'Test message: j' from dual
union
select 'Test message: k' from dual
union
select 'Test message: ś' from dual
union
select 'Test message: ź' from dual
union
select 'Test message: ń' from dual

Thanks. We'll investigate and will send you some tests shortly.

Hello,

I have tested with nvarchar2 in the query:

Quote

select N'Test message: j' from dual union
select N'Test message: k' from dual union
select N'Test message: ś' from dual union
select N'Test message: ź' from dual union
select N'Test message: ń' from dual;

The issue still persists.
I encountered the same issue with sqlplus, but, I encountered no issue with PL/SQL Developer nor with SQL Workbench/J.

[Linked Image]

I use system variable NLS_LANG="FRENCH_FRANCE.AL32UTF8"

Regards,
Stéphane.