Some wierd encoding issue maybe?
Posted: 13.05.2023, 19:09
So I have a simple VARCHAR field in an Oracle database. There is a text with a special character (ő) in it.
When I execute a select with Zeos (or PL/SQL for that matter) this character gets converted, turning it to "o", but... only in this record. In other records the same character appears normally.
HOWEVER
There's an application written in C#, which correctly reads the text out.
My idea is that it was loaded incorrectly (like o with the wave) so I tried to get the DUMP of it, which returned: According to this, my "ő" is stored as 0xC3. Now the funny part, if I try to decode 0xC3 with every codepage available in Delphi (TEncoding.GetEncoding) I never get the character I'm looking for.
NLS_CHARACTERSET is AL32UTF8 on the server, if it makes any difference.
Can anyone make any sense out of this...? Can I make Zeos read this out as the C# application does?
Any tips are welcome.
When I execute a select with Zeos (or PL/SQL for that matter) this character gets converted, turning it to "o", but... only in this record. In other records the same character appears normally.
HOWEVER
There's an application written in C#, which correctly reads the text out.
My idea is that it was loaded incorrectly (like o with the wave) so I tried to get the DUMP of it, which returned: According to this, my "ő" is stored as 0xC3. Now the funny part, if I try to decode 0xC3 with every codepage available in Delphi (TEncoding.GetEncoding) I never get the character I'm looking for.
NLS_CHARACTERSET is AL32UTF8 on the server, if it makes any difference.
Can anyone make any sense out of this...? Can I make Zeos read this out as the C# application does?
Any tips are welcome.