Questions and discussion about developing processes and programming in PHP, JavaScript, web services & REST API.

Moderator: amosbatto

Forum rules: Please search to see if a question has already asked before creating a new topic. Please don't post the same question in multiple forums.
By talal007
#821930
Good morning,

I am using ProcessMaker 3.2.1, and 3.3.0 bitnami stack ,

The connection is established with SQL Server using dblib64 from ProcessMaker explanation for 3.2.x, a connection was done and data can be retrieved but not properly, the problem it doesn't read it as Arabic characters , it show non-arabic characters.


then, I tried ProcessMaker 3.3 bitnami , and the same problem faced.

the strange thing that using same sqlsrv.dlls of ProcessMaker 3.3 for wamp server php 7.1 can retrieve arabic letters correctly with UTF-8 from the same SQL Server database.


any advice to make ProcessMaker 3.3 read Arabic letters from SQL Server in bitnami stack ?
User avatar
By amosbatto
#821977
I finally found some time to test this. What version of SQL Server are you using and in what version of Windows?
By talal007
#821999
programerboy wrote: Wed Dec 12, 2018 12:49 am Hi,

You can use sqlsrv extension in php7 and processmaker 3.3:
https://wiki.processmaker.com/3.3/Datab ... ions/MSSQL

You can get your driver and check requirement match with your server in these links:
https://docs.microsoft.com/en-us/sql/co ... erver-2017
https://docs.microsoft.com/en-us/sql/co ... erver-2017

Please check it and tell us your result.
Thanks
Thank your for replay
its works
regards
User avatar
By amosbatto
#822014
programerboy wrote: Wed Dec 12, 2018 12:49 am You can use sqlsrv extension in php7 and processmaker 3.3:
https://wiki.processmaker.com/3.3/Datab ... ions/MSSQL

You can get your driver and check requirement match with your server in these links:
https://docs.microsoft.com/en-us/sql/co ... erver-2017
https://docs.microsoft.com/en-us/sql/co ... erver-2017
Thanks programerboy for finding those links.
I added those links to the documentation for people who aren't using CentOS:
https://wiki.processmaker.com/3.3/Datab ... SRV_module

Hi everyone! I am trying to create a link to a ex[…]

Routing Rule

Could you please share a screenshot from your proc[…]

PM ONLY SHOWING SYSTEM

I didn't work on this version of PM but I could su[…]

radio has a data automatic

Make sure you have assigned a variable to the radi[…]