We have a PB 2017 app accessing a SQLANywhere Database which has the character set for CHAR types as windows-1252 (its an old app) but NCHARS are UTF8.  The issue is the SQL ANywhere SQL processor automatically converts the SQL syntax to the CHAR format before executng it.

This means that any query which contains extended Character Literals fails.

select 'ABC_세계를 향한 대화, 유니코드로 하십시오.' from dummy;

returns 'ABC_'

 

 

This means unless we can somehow change this behavior during SQL execution, we need to change the CHAR set to UTF8.

 

Has anyone any experience with what impact this would have on the PowerBuilder App?  Im assuming you might have to regenerate the datawindows?