• Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
    Dedicated community for Japanese speakers
  • 한국 커뮤니티
    Dedicated community for Korean speakers
Exit
0

Problem with Unicode ( Arabic / Farsi )

New Here ,
Nov 10, 2019 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

206

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
community guidelines
LEGEND ,
Nov 12, 2019 Nov 12, 2019

Copy link to clipboard

Copied

LATEST

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

 

V/r,

 

^ _ ^

Votes

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
community guidelines
Resources
Documentation