UTF8 DB.Recipient of datafile cannot handle accent marks.
Posted: Sep 03, 2015
Hi Jan, This has occurred before. Issue/Symptoms:
CIM fails without error when trying to load French characters. Codepage is UTF-8. CIM seems to load normally until cedilla ( ~) or French accent mark is encountered then CIM load fails without error. Issue arose when doing CIM load for new French site. Note that CIM completed successfully for 2 previous French sites.
Bad data caused CIM load to fail.
French users removed bad data then CIM loaded normally.
Replied: Sep 08, 2015
Unfortunately this does not apply to our issue. 1) Have UTF-8 database created with Latin Spanish data. 2) Data file sent to vendor using Ecommerce module. 3) Vendor (who is in Mexico) DOES NOT WANT ANY exported QAD data in the file to contain any accent marks (so they have asked us to export 'e' instead of 'é' with an accent mark (also change a,i,o,u and n) letters which have special characters (accent or tilde over the letter n). I'm wanting to know if there is an easy way to remove the accent and tilde marks in the file other than by searching and replacing all text occurrences in the Progress mapping of the Ecommerce. The Ecommerce file is an XML file.