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
By TarekEladly
#823313
Ok thanks for you all but i have found a solution :)

Edit:
<Instalation Path>\apps\processmaker\htdocs\thirdparty\creole\drivers\mssql\MSSQLConnection.php

Change:
Code: Select all
$opt = [
                'UID' => $user,
                'PWD' => $pw,
                'Database' => $dsninfo['database']
            ];

To:
Code: Select all
$opt = [
                'UID' => $user,
                'PWD' => $pw,
                'Database' => $dsninfo['database'],
                'CharacterSet' => 'UTF-8'
            ];

And thanks again :)
Last edited by TarekEladly on Tue Mar 12, 2019 5:08 am, edited 2 times in total.
By TarekEladly
#823339
Hi All,

@amosbatto do what you see fit, one thing in this solution don't work well the suggestion control I am working on it and I will keep you updated

@programerboy they always do that and always make our life harder :D

Thanks
By TarekEladly
#823342
Hi All,
For the suggestion control do this

Edit:
<Instalation Path>\apps\processmaker\htdocs\workflow\engine\src\ProcessMaker\BusinessModel\DynaForm\SuggestTrait.php

Change:
Code: Select all
$where = $isWhere ? "WHERE " . $col . " LIKE '%" . $qf . "%'" : $where . " AND " . $col . " LIKE '%" . $qf . "%'";

To:
Code: Select all
$where = $isWhere ? "WHERE " . $col . " LIKE N'%" . $qf . "%'" : $where . " AND " . $col . " LIKE N'%" . $qf . "%'";

Tested with MS SQL and MY SQL

Now you can use any language with ProcessMaker :wink:

Thanks
LDAP Connection problems

Are you sure that you don't have a firewall in you[…]

Grid dropdown

If you have a grid which contains the following fi[…]

Timezone issue

You have to use PHP in triggers. See: https://stac[…]

Your Dynaform won't work, because you are letting […]