i need to capture Spanish characters in char fields in an app (Progress
rdbms) and export data to MySql for use on a website.
i have set the windows xp language to various Spanish (ie., Spanish-Mexico),
and chars seem to enter/display fine in the app, however, on export the data
appears to be in Latin1 format. i need to ensure chars are in UTF-8 format.
to test the app i have cut-pasted text created in UTF-8 into the app field,
and it exports fine. the app export uses a "convert format utf-8" but this
only seems to work if the data was input in UTF-8. how can i ensure the
UTF-8 format when entering??
thank you...