Questions and discussion about using ProcessMaker: user interface, running cases & functionality
By aboudmurad
#829034
when I try to connect my ProcessMaker to MYSQL ,the connection is alright But When retrieving data from Database the data shown like "????" So I think that was from encoding of DB. and ProcessMaker dose not support other encoding collation.

MSSQL collation = SQL_Latin1_General_CP1_CI_AS
PM MySQL Encode = utf8- Unicode ...ONLY

query is :
SELECT ID,Name FROM FamilyMemberWorksName

Finally How To retrieving data as it ?
Thank alot & Attachment belowe
Attachments
SQl Respones.PNG
SQl Respones.PNG (11.65 KiB) Viewed 12735 times
encoding.PNG
encoding.PNG (14.1 KiB) Viewed 12735 times
MSSQL.png
MSSQL.png (29.89 KiB) Viewed 12735 times
#829038
Hi,
You can use the sqlsrv library to connect to your database and not use the mssql library.
This is possible if you are using Process Maker version 3.3 or higher.
https://pmlearning.info
Thanks

A 1xbet clone script is a pre-designed software so[…]

4rabet clone script is enabling entrepreneurs to e[…]

Parimatch clone script is enabling entrepreneurs t[…]

In the world of cryptocurrency, a wallet is an app[…]