ProcessMaker Forum | BPM Workflow Simplified

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

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

thank you
I'll try