Hi,
We managed to find a solution ourselves now.
Just for documentation in this thread, and possibly some help for anyone else running into this problem in the future, here are how we solved it:
We added:
- env:
- name: LANG
value: en_US.UTF-8
In the YAML-file for the Integration Runtime.
And we set the following in the odbc.ini
[INTEGRATION]
DRIVER=/opt/ibm/ace-13/server/ODBC/drivers/lib/UKpsql95.so
ClientEncoding=UTF8
IANAAppCodePage=106
[ODBC]
IANAAppCodePage=4
UNICODE=UTF-8
After these changes the encoding ("Unconvertable character") problem was solved for us.
/Staffan
------------------------------
Staffan Olsson
------------------------------
Original Message:
Sent: Wed October 08, 2025 02:34 AM
From: Staffan Olsson
Subject: ACE Encoding Problem
Hi,
We have a encoding problem that I hope anyone of you out there can help us with.
We are running ACE 13 on OpenShift and using a PostgreSQL database version 16.
When selecting data from the DB we get a encoding problem ("unconvertable character") in ACE due to national characters (Swedish characters) in the data.
We know that the DB are UTF-8.
We know that the data is UTF-8.
But ACE think it is ASCII and give the following:
<Text>Unconvertable character</Text>
<Insert>
<Type>5</Type>
<Text>d6</Text>
</Insert>
<Insert>
<Type>5</Type>
<Text>d6535452414e44504f4c4152</Text>
</Insert>
The ODBC log give us: "...cannot be converted to Unicode from codepage '367'..." (ACE think this is ASCII).
So this boils it down for us to that we think the problem is the PostgreSQL driver and/or settings in odbc.ini or OpenShift.
Have anyone of you run into this problem?
And if so, how did you fix it?
What PostgreSQL driver did you use?
What settings did you set in odbc.ini?
...?
Hope anyone of you can give us some help
Regards
Staffan
------------------------------
Staffan Olsson
------------------------------