mySQL collation question & tinymce

whiteshadow

Please help.. im at my wits end

Im creating a basic CMS for a clients site
Im using tinymce so they can submit html
and then ASP and mySQL to store it in the table

So when they submit a query might look like

Update CodesTable set Code_Desc = 
'<p>The primary objective of the Code is the regulation of commercial 
marketing communications in the interest of consumers.</p>' where 
Section_Num = 1 AND Code_Num = 1

that worked fine.

The next record is a bit longer. Also within the text it has things like quotes and semi colons.

so it looks like this

Update CodesTable set Code_Desc = 
'<p>For the purposes of the Code: <br />(a) a word importing the singular 
shall be read as also importing the plural, and a word importing the plural 
shall be read as also importing the singular; <br />(b) &ldquo;person&rdquo;
 should be construed as including legal persons and groups, as appropriate; 
<br />(c) every word importing the masculine gender should be construed 
as if it also imported the feminine gender unless the contrary intention 
appears. Every word importing the feminine gender should be construed 
as if it also imported the masculine gender unless the contrary intention 
appears. </p>' 
where Section_Num = 2 AND Code_Num = 2

It doesnt return an error but it also doesnt seem to update. When i run this query directly into mySQL it just states

Affected rows: 0 (Query took 0.0016 sec)

Is this somthing to do with the Collation for this field?
I have it set as the default which is latin1_swedish_ci

Or is it that i have semicolons in the actual text?

Any advice greatly appreciated

JohnK

I presume you've checked the obvious that there is in fact a record with a Section_Num of 2 and a Code_Num of 2 right? Other than that, have you tried replacing the text with something shorter?

Adam

Also presumably the field type is set to a type that can hold that amount of text?

whiteshadow

got it sorted i think. thanks for the replys
i just had to make sure to replace quotes
and semi colons with their code equivs.