- Glenn Barber
- PowerBuilder
- Tuesday, 10 December 2024 09:43 PM UTC
Hi - Help Needed
Using PB 17. Connecting to a legacy SQL Anywhere Database V17 with Char Character Encoding Windows-1252. NChar encoding UTF-8
We have no trouble with reading and writing foreign language characters to nvarchar columns using a connection with Bind Valiables - however we cannot generally use this as the use of Bind Variables causes problems with our app with very large queries. At the time converting the database is not practical.
So when we connect using a datawindow to update nvarchar UTF8 foreign characters, we use the Bind Variable in the ODBC connection - this works well for extended characters reads and writes.
The problem is with the SQLSA using format 3 or 4 Dynamic SQL - even if we tell it to use the SQLCA_BIND connection in the prepare, queries and database functions still return garbage characters when foreign characters (Japanese, Cyrillic, etc) are used in metadata.
How can we do dynamic SQL and get it to support foreign characters??
This is sort of urgently needed fix.
Any help or suggestions would be appreciated.
Thanks
Glenn Barber
Find Questions by Tag
Helpful?
If a reply or comment is helpful for you, please don’t hesitate to click the Helpful button. This action is further confirmation of their invaluable contribution to the Appeon Community.