Hi all. I have a sticky issue. We are receiving XML data over MQ to AQ. MQ is sending UTF-8 data, as it should. Our Linux server is set up for UTF-8. BUT our database, (11.2.0.4.0) is set up with we8iso8859p1, so MQManager does not convert. In addition, MQ defines this paylaod as MQSTR, so AQ forces the payload into text_body. Our MQ admins say that the mqmanager converts to the OS dataset automatically. Since there are many queues on this mqmanager we can not change this setting. We also can not change the MQSTR setting on the sending application, as there are multiple consumers for this data.
We need a way, on AQ's MQGET issued from the Java API behind the scense, to tell MQ to translate to the Oracle database characterset. According to the MQ documentation the MQ Java API allows for this, and according to Oracle AQ documentation this is mentioned as possible, but I can find NO examples or giudance on how to do it.
Can anyone help with this? Preferably with an example.