> > thanks a lot Russ . from the links you gave I realized that maybe
> the cfprocessingdirective tag is the solution . but I don't know
> what's going
> > wrong that when I wrap my cfquery tag inside the
> cfprocessingdirective it gives me error and says that the
> </cfprocessingdirective> tag doesn't
> > have a start tag!
> > here's the code I don't know what's wrong :
> >
> > <cfprocessingdirective pageencoding="utf-8">
> > <cfquery name="qInsert" datasource="CFflexdb">
> > insert into main(name,writer) values('ã','È')
> > </cfquery>
> > </cfprocessingdirective>
>
> You can't wrap code within CFPROCESSINGDIRECTIVE. You simply place it
> at the top of the page, without a closing tag. But in any case, that
> will only control the page that's being generated (not the queries
> within the page).
>
> You'll need to ensure that data sent to the page is also UTF-8, using
> setEncoding:
> http://www.adobe.
com/support/coldfusion/int>
ernationalization/internationalization_cfmx/internationalization_cfmx4.
> html
>
> Dave Watts, CTO, Fig Leaf Software
> http://www.figleaf.com/
> http://training.figleaf.com/
>
> Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on
> GSA Schedule, and provides the highest caliber vendor-authorized
> instruction at our training
center
--------------------------
thank you all guys , I fixed it . first I added these four tags to the top of
my code:
<cfprocessingdirective pageencoding="utf-8">
<cfset setEncoding("form","utf-8")>
<cfset setEncoding("url","utf-8")>
<cfcontent type="text/html ; charset=UTF-8">
and I also checked the "Enable High ASCII characters and Unicode for data
sources configured for non-Latin characters." in AdminPage>Data Sources> Edit
data source > show advanced setting
thank you all
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:339002
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
