Euro symbols issue changing ASAProv.90 to SAOLEDB.16
I am facing a strange beahviour during migration test in order to upgrade from IQ 12.7 to IQ 16.0 SP08.
Looking the data into the DB they are equal in both instances, but when an extrnal software try to extract them to an XML files I obtain two different results. The external software uses an ADODB connection.
The problem seems to be related to the EURO symbol (€).
While in OLD setup the XML output file shows always the '€' symbol, in the NEW setup I have sometimes the '€' symbol and some other times an ASCII character showed as SUB in notepad++ instead the '€' symbol.
The strange thing is that apparently I have different behaviour for the same original data.
Herefater I report our configurations:
** OLD ** Sybase IQ 12.7 ESD 4
Provider = ASAProv.90
** NEW ** SAP IQ 16.0 SP08 PL30
Provider = SAOLEDB.16
Do you have any suggestion about how to fix this very strange issue?