Skip to main content

Hi,

please is possible to have SQL statement in PIC N variable? I need this because in WHERE condition I have variable with Chinese characters, and I am worried, if I try to convert it, I will loose these chars. Because computer on this program runs have English locale.

Is there any solution for such a case?

Thanks.


#COBOL
#SQL
#unicode

Hi,

please is possible to have SQL statement in PIC N variable? I need this because in WHERE condition I have variable with Chinese characters, and I am worried, if I try to convert it, I will loose these chars. Because computer on this program runs have English locale.

Is there any solution for such a case?

Thanks.


#COBOL
#SQL
#unicode
What database are you accessing and what embedded SQL technology are you using?
If you are using OpenESQL to access your database through ODBC then you can define your host variables as PIC N data-types and they will be treated as Unicode.
Terms & ConditionsAccessibility statement