Highlighted

Problem with Unicode ( Arabic / Farsi )

New Here ,
Nov 10, 2019

Copy link to clipboard

Copied

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

TOPICS
Connector, Database access

Views

120

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more

Problem with Unicode ( Arabic / Farsi )

New Here ,
Nov 10, 2019

Copy link to clipboard

Copied

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

TOPICS
Connector, Database access

Views

121

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Nov 10, 2019 0
LEGEND ,
Nov 12, 2019

Copy link to clipboard

Copied

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

 

V/r,

 

^ _ ^

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
Nov 12, 2019 0