I am currently involved in a project which uses an Infopath form to gather data and then submits that data to an Oracle database. (Infopath Form is hosted on Sharepoint)
If a user populates the form fields by typing in the data, there's no problem All the data is entered in to the DB correctly.
However, if a user copied and pasted text in to the form from Word for example, then there can be problems. For example, single quotes, tabs and/or other special characters often appear as squares or upside down question marks (¿).
This seems to be because the character that is being passed by Infopath is not a valid character in the Oracle DB character set.
Does anybody have any advice on how to rectify this?
Thank you in advance