PowerBuilder 6.5 to 11.5 migration issues - Special characters in multilineedit box

[Rajarsi Ghosh]

Hi

I am facing a peculiar problem while migrating an existing application
from 6.5 to 11.5.

The multilineedit box that we had in 6.5 was able to handle all the
special character that was copy-pasted but in 11.5 few of the special
characters are not working when copy-pasted from another documents.
(Example: single quotes ' double quotes " hypen -).

The error I am getting is "Database error code 2402
Error converting characters into server's character set. Some
character(s) could not be converted."

Any idea what is going wrong?

Thanks
Rajarsi

[Jeremy Lakeman]

I doubt you are pasting simple quotes and hyphens, it's more likely
you are pasting special quotes and some other unicode hyphen
character.

When PB was ASCII strings only, the conversion to simple ASCII
characters was done by the windows clipboard when you pasted the text.
Now in PB11.5 the conversion from unicode is done in the database
layer since I'm guessing you are updating a varchar column, and is
dependent on the code page used for the translation.

You can either convert your database columns to unicode, or make sure
the DB client and server are using the same code page for string
conversions.