AnsweredAssumed Answered

PI Interface for RDBMS problem

Question asked by Tomas Stark Champion on Dec 19, 2019

Hi,

 

we use the PI Interface for RDBMS to read data from an Oracle database.

 

Everything works fine, except when we have the Swedish letters Å, Ä, or Ö in the P1 argument, for example:

 

P1="S-IK001-00-854 ÖVY Damm" P2=TS /RBO

 

The SELECT statement used is

 

SELECT TIME_STAMP, VALUE, 0 FROM PE_HISDATA WHERE TARGETNAME = ? AND TIME_STAMP > ? ORDER BY TIME_STAMP ASC;

 

So when the PI Interface fills in the P1 and P2 arguments in the SQL-statement it obviously does not support the Swedish letters (127 bit ASCII only?).

 

On the Oracle side, Å, Ä, and Ö are supported, so we can execute the same SQL statement  and get results. For example:

 

SELECT TIME_STAMP, VALUE, 0 FROM PE_HISDATA WHERE TARGETNAME = 'S-IK001-00-854 ÖVY Damm' ORDER BY TIME_STAMP ASC;

 

Regards,

Tomas

Outcomes