> Hi,
>
> the first thing to check is that you are using the correct datatype in
> the
> database. Many foreign languages require double byte characters which
> requires you to us ethe n prefix data tyles, e.g. nVarchar, nChar etc.
>
> You also need to consider your collation settings.
> http://msdn.microsoft.com/en-us/library/ms144260.aspx
>
> And you need to consider the character encoding on the cf pages to
> make sure
> is displays and submits data in the correct encoding format.
> http://www.adobe.
com/support/coldfusion/int>
ernationalization/internationalization_cfmx/internationalization_cfmx3.
> html
>
>
>
> --
> Russ Michaels
> www.cfmldeveloper.com - Supporting the CF community since 1999
> FREE ColdFusion/Railo hosting for developers.
>
> blog: www.michaels.me.uk
-------------------------------------------
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 :
<cfcomponent>
<cfcontent type="text/html ; charset=UTF-8">
<cffunction name="CFfunction" access="remote" returntype="Query">
<cfquery name="qData" datasource="CFflexdb">
select * from main
</cfquery>
<cfreturn "#qData#">
</cffunction>
<cffunction name="CFfunction2" access="remote" returntype="void">
<cfargument name="name" type="string" required="true">
<cfargument name="writer" type="string" required="true">
<cfquery name="qInsert" datasource="CFflexdb">
insert into main(name,writer)
values(<cfqueryparam value=#arguments.name#
cfsqltype="cf_sql_varchar">,<cfqueryparam value=#arguments.writer#
cfsqltype="cf_sql_varchar">)
</cfquery>
</cffunction>
<cffunction name="CFfunction3" access="remote" returntype="void">
<cfargument name="name2" type="string" required="true">
<cfargument name="writer2" type="string" required="true">
<cfquery name="qDelete" datasource="CFflexdb">
delete from main
where name=<cfqueryparam value=#arguments.name2#
cfsqltype="cf_sql_varchar">
</cfquery>
</cffunction>
<cfprocessingdirective pageencoding="utf-8">
<cfquery name="qInsert" datasource="CFflexdb">
insert into main(name,writer) values('Ù
','ب')
</cfquery>
</cfprocessingdirective>
</cfcomponent>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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:338967
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
