Skip to main content
Participant
Nov 10, 2019 10:39 AM UTC
Question

Problem with Unicode ( Arabic / Farsi )

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

This topic is closed to new replies. Start a new post to keep the conversation going.

1 reply

WolfShade
Legend
Nov 12, 2019 2:30 PM UTC

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

 

V/r,

 

^ _ ^

Translate