Tag-Archive for » Coldfusion error: Hebrew characters failed to display properly – UTF8 «
03
Sep 2009
Problem description-
Setup MySQL database and CF DSN but the Hebrew characters fail to display properly – UTF8.
Temporary work around-
Recreate the DSN and set the driver type from MySQL 3 to MySQL 4/5
Note: This solves only for characters already stored in the DB – if I update the text using coldfusion – then ? Marks appear instead
Permanent solution-
Please include this code in your script-
<cfscript>
setEncoding(”URL”, “UTF-8″);
setEncoding(”Form”, “UTF-8″);
</cfscript>
At the top of form loading script.
In CFAdmin, under the connection string field specify these piece of entry-
useUnicode=true&characterEncoding=UTF-8
Category: Coldfusion
Leave a Comment
Recent Comments