> 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/internationalization/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
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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:338969
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
