[talal007]

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 ?

[amosbatto]

I don't have time to test this today, but here is where I would start:
https://stackoverflow.com/questions/343 ... rosoft-sql
I'll try it out tomorrow, and let you know if I had any success.

[amosbatto]

I finally found some time to test this. What version of SQL Server are you using and in what version of Windows?

[talal007]

I finally found some time to test this. What version of SQL Server are you using and in what version of Windows?

I used SQL server2016

[programerboy]

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

[talal007]

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

[amosbatto]

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

[TarekEladly]

Hi,
I have tries everything with sqlsrv and still getting ??? any help please.
Windows Server 2016
SQl Server 2016
ProcessMaker 3.3.3

[TarekEladly]

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

[amosbatto]

TarekEladly, Nice solution!

Do you want me to file a bug report about this?

[programerboy]

Hi,

I told in this post:
https://bugs.processmaker.com/view.php?id=26684
But the development team did not pay attention!

Thanks

[TarekEladly]

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

Thanks

[TarekEladly]

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

Thanks

[amosbatto]

Thanks TarekEladly and programerboy for figuring out how to fix this.

I filed an internal bug report about this problem:
https://processmaker.atlassian.net/browse/TRI-3790