1. Rengaraj Arumugam
  2. PowerBuilder
  3. Thursday, 3 October 2024 11:59 AM UTC

Good Day Team,

Recently we moved from PowerBuilder 11 to PowerBuilder 2022 R3. We noticed issue in the word document print. We have local document print and network document print accomplish by OLE.

 

Now we found the issue in “franzoesisch” special character, it is not supporting the french letters in PowerBuilder 2022
for example.

PowerBuilder 2022 R3 displaying using Datawindow from the Oracle 19c database like below (Not Correct)

les frères et surs

 

PowerBuilder 11 displaying using Datawindow from the Oracle 19c database like below (Correct)

les frères et sœurs

 

Please suggest, any dll need to import or any code changes need to this?

 

 

 

Thanks,

Renga.

Roland Smith Accepted Answer Pending Moderation
  1. Thursday, 3 October 2024 17:07 PM UTC
  2. PowerBuilder
  3. # 1

Are you printing to paper and then scanning it in to show us or was it printed to PDF?

What happens if you open the document in Word? Is it correct? What happens when printing from Word?

Is the Word document generated by the PB app? If yes, how?

Comment
There are no comments made yet.
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Thursday, 3 October 2024 16:08 PM UTC
  2. PowerBuilder
  3. # 2

Hi Rengaraj;

  How is your App trying to accomplish this task ( via DDE, DLL call, OLE, etc. )?

Regards .. Chris

Comment
  1. Rengaraj Arumugam
  2. Friday, 4 October 2024 17:52 PM UTC
Thanks Chris and Arnd!!



Now we can be able to access special character using below DBParm. Could you please suggest is this correct way to access the application?



SQLCA.DBParm="NLS_Charset='Local'"



Thanks,

Renga
  1. Helpful
  1. Arnd Schmidt
  2. Friday, 4 October 2024 19:42 PM UTC
If you set "local" then the OCI client uses the current character set defined by the NLS_LANG parameter on the local computer.

https://docs.appeon.com/pb2022r3/connection_reference/NLS_Charset.html

More information about NLS_LANG:

https://www.oracle.com/database/technologies/faq-nls-lang.html
  1. Helpful 1
  1. Rengaraj Arumugam
  2. Tuesday, 8 October 2024 05:51 AM UTC
if we set "local" (like below) in the PowerBuilder, that means DB local (NLS character) character, can use in the PowerBuilder application, right?

PB CODE:

SQLCA.DBParm="NLS_Charset='Local'"
  1. Helpful
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.