updating trademark symbol in mysql db using CF 8

hello all,

 

i using cf 8 update records in mysql (ver. 5) database.

the form basic update form. same thing worked fine when using ms access.

but, problem having inserting (updating actually) trademark symbol mysql table.

it adds symbol fine on cf form add record. using phpmyadmin, trademark symbol show fine. can edit record one(1) time using either web-based form or phpmyadmin.  save change 1 time , trademark symbol still correct.  minute "update" record second time changes double quotes symbol (") , truncates text following position symbol was.  happens both when editing form in phpmyadmin , cf form on site.

 

the ccf ode, in part, save record :

-------------------------------------------------------------------

 

<cfquery  name="editpromotion" datasource="toppssqldb" username="topps20105" password="toppsmysql">   
update promotions

 

set title = <cfif form.title neq "">
  <cfqueryparam value="#form.title#" cfsqltype="cf_sql_varchar">,
<cfelse>
  <cfqueryparam null="true" cfsqltype="cf_sql_varchar">,
</cfif>

 

-------------------------------------------------------------------

 

the field in mysql set utf-8 fields.

 

if can help, great.

i've spent couple days on looking solution....

 

thanks!

tim

i think because in text quotes (") or other special character ('), , db thinks end of data. need escape characters # - adding 1 more #.

maybe wrong.

More discussions in Database Access

adobe