tweak_master
New Member
When i connect to our database (UNIX) from the appbuilder and execute a query, some special characters in the result on the screen (terminal) are wrong.
For example what must be "BELGIë" is shown on the screen as "BELGIÙ".
I did some research and found I had to put some parameters in de startup.pf file.
Untill now, we worked character-based in UNIX, so I looked up the old (working) settings from the unix environment:
-cpinternal iso8859-1
-cpstream ibm850
-cpterm ibm850
-cpcoll Basic
-cpcase Basic
...
I changed the pf-file, but nothing works! I've been messing around a lot with the parameters, but still, the output on the screen stays wrong.
Strangely enough, when i put next code before the for-each, output is correct. When I remove "paged" from this line, output is wrong again:
"output to terminal PAGED." => "BELGIë" = ok
"output to terminal. => "BELGIÙ" = nok
When i use next function, output is also correct:
CODEPAGE-CONVERT("BELGIÙ","ibm850":U,"iso8859-1":u).
Changing the cpinternal to ibm850 has no effect... We would like to use our database for windows-apps in the future together with the unix-apps, so we cannot convert or change data in the DB. What am I doing wrong here?
For example what must be "BELGIë" is shown on the screen as "BELGIÙ".
I did some research and found I had to put some parameters in de startup.pf file.
Untill now, we worked character-based in UNIX, so I looked up the old (working) settings from the unix environment:
-cpinternal iso8859-1
-cpstream ibm850
-cpterm ibm850
-cpcoll Basic
-cpcase Basic
...
I changed the pf-file, but nothing works! I've been messing around a lot with the parameters, but still, the output on the screen stays wrong.
Strangely enough, when i put next code before the for-each, output is correct. When I remove "paged" from this line, output is wrong again:
"output to terminal PAGED." => "BELGIë" = ok
"output to terminal. => "BELGIÙ" = nok
When i use next function, output is also correct:
CODEPAGE-CONVERT("BELGIÙ","ibm850":U,"iso8859-1":u).
Changing the cpinternal to ibm850 has no effect... We would like to use our database for windows-apps in the future together with the unix-apps, so we cannot convert or change data in the DB. What am I doing wrong here?