Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Euro symbols issue changing ASAProv.90 to SAOLEDB.16

Hi all,

          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

Collation ISO_BINENG

Provider = ASAProv.90

** NEW ** SAP IQ 16.0 SP08 PL30

DefaultCollation ISO_BINENG

DefaultNcharCollation UCA

Provider = SAOLEDB.16



Do you have any suggestion about how to fix this very strange issue?



Best regards,

Stefano

Tags:
Not what you were looking for? View more on this topic or Ask a question