Question
UTF-8
I have inserted data to MYSQL ver4 by Coldfusion MX-6 as
UTF-8 but can not view them correctly. the thing which i see is
only "?".
My site is Multi-language and I need to use the best encoding for that.
The thing which I was interested is I can see the inserted data by PHP normally but not by CFML.
Let me tell the exact problem:
A) When I use the following formatting, I can See the inserted data in MYSQL by ColdFusion and PHP Correctly but there are 2 mistakes
===========================================
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<cfprocessingdirective pageEncoding="utf-8">
<cfcontent type="text/html; charset=iso-8859-1">
===========================================
The problems are:
1- The Data which will insert in my DB will be HEX codes like: " ب..." which I think will incease MySQL Size. (I am Not Sure)
2- I need to write in HEX format for the Contetnt of my HTML Body. And this is too hard
B) I also Can use the following Codes"
===========================================
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<cfprocessingdirective pageEncoding="utf-8">
<cfcontent type="text/html; charset=UTF-8">
<cfscript>
SetEncoding("form", "iso-8859-1");
</cfscript>
===========================================
By these codes I can write in Content of HTML body easy (not with HEX Codes). and also I can read the inserted data in MySQL by PHP. BUT NOT IN COLDFUSION!!!! I mease instead of correct symbols I can see only "???????"
I realy confused.
My site is Multi-language and I need to use the best encoding for that.
The thing which I was interested is I can see the inserted data by PHP normally but not by CFML.
Let me tell the exact problem:
A) When I use the following formatting, I can See the inserted data in MYSQL by ColdFusion and PHP Correctly but there are 2 mistakes
===========================================
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<cfprocessingdirective pageEncoding="utf-8">
<cfcontent type="text/html; charset=iso-8859-1">
===========================================
The problems are:
1- The Data which will insert in my DB will be HEX codes like: " ب..." which I think will incease MySQL Size. (I am Not Sure)
2- I need to write in HEX format for the Contetnt of my HTML Body. And this is too hard
B) I also Can use the following Codes"
===========================================
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<cfprocessingdirective pageEncoding="utf-8">
<cfcontent type="text/html; charset=UTF-8">
<cfscript>
SetEncoding("form", "iso-8859-1");
</cfscript>
===========================================
By these codes I can write in Content of HTML body easy (not with HEX Codes). and also I can read the inserted data in MySQL by PHP. BUT NOT IN COLDFUSION!!!! I mease instead of correct symbols I can see only "???????"
I realy confused.
AdChoices