We have a PB app in 12.6 (moving to PB 2017) which is largely used by users in English
However we have the need to enter some information (usually foreign language names) in native Character sets - such as Chinese, Korean, Eastern European.
Usually the users want to cut and pase the information from excel sheets where the information appears correctly in windows. It appears correctly when intially pasted but does not seem to be stored or redisplayed correctly.
We are using SQL Anywhere 16 as the database.
We have found that just defining the data fields as nvarchars doesn't seem to be a solution.