>What's the code you are using to insert it?
>
>Also, you may want to check the advanced datasource settings to see if there
>is a UTF-8 option that needs enabling.
>
>Mark
>
>
>
>>
Here is the code:
UPDATE citiContent
SET
koreanSiteSection = <cfqueryparam
value="#arguments.koreanSiteSection#" cfsqltype="cf_sql_varchar">,
koreanSubSection = <cfqueryparam
value="#arguments.koreanSubSection#" cfsqltype="cf_sql_varchar">,
koreanSubSection2 = <cfqueryparam
value="#arguments.koreanSubSection2#" cfsqltype="cf_sql_varchar">,
koreanSubSection3 = <cfqueryparam
value="#arguments.koreanSubSection3#" cfsqltype="cf_sql_varchar">,
koreanText =
N'#arguments.koreanText#',
dateLastUpdated = <cfqueryparam
value="#arguments.dateLastUpdated#" cfsqltype="cf_sql_varchar">,
lastUpdatedBy = <cfqueryparam
value="#arguments.lastUpdatedBy#"
cfsqltype="cf_sql_varchar">
WHERE contentID = <cfqueryparam
value="#arguments.contentID#"
cfsqltype="cf_sql_varchar">
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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:348221
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
