Problem with Unicode ( Arabic / Farsi )

Report · Nov 10, 2019

Hi,

I have a problem with character set in unicode for Arabic & Farsi. I try to add record to MySql ( ver 5.7 ) in Arabic / Farsi Languages but data saved to database as "???????", i dont have problem to read data because it will show correctly in the CFOUTPUT but in the database saved like "??????". I use coldfuaion 9 and mysql 5.7. Itry Utf8, utf8mb4 but the rasult is the same. how can i save data in mysql which show the record as real character?

Thanks

Report · Nov 12, 2019

What datatype are you using for those values? It should be a double-bit datatype.

V/r,

^ _ ^