- Mon Mar 22, 2021 6:51 am
#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
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 (11.65 KiB) Viewed 12871 times
encoding.PNG (14.1 KiB) Viewed 12871 times
MSSQL.png (29.89 KiB) Viewed 12871 times