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 12795 times
encoding.PNG
encoding.PNG (14.1 KiB) Viewed 12795 times
MSSQL.png
MSSQL.png (29.89 KiB) Viewed 12795 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
Want to create your own meme coin?

In the world of cryptocurrencies, a unique and exc[…]

The market for cryptocurrencies is demonstrating a[…]

What's SAP FICO?

Embarking on a dissertation can be one of the most[…]

Hello. For rental housing, there are software solu[…]