[FX.php List] Bad apostrophe character confounds FMP

Mon Dec 10 14:31:55 MST 2007

Jonathan,

A couple of things...

(1) Is the PHP file saved as UTF-8, no BOM as I described for BBEdit?

(2) You've got HTML content...

<br><BR>ON PAGE LOAD:<br>Query error: 0<br>Query count: 1<br>

...BEFORE even the DOCTYPE is declared. That should come after, in the <BODY> portion. I guess it's possible that's confusing the browser since it has to deal with characters before the encoding and DOCTYPE is declared.

Just guess, try to rearrange it?

-Troy

> OK...Seeing is believing.
> 
> Here is link to the entire solution boiled down to one page.
> 
> http://www.exit445.com/mvll/odoherty.php
> 
> The page re-loads the original offending field and allows creation of 
> a new record based on that single field.  The page has UTF encoding. 
> Attempting to create the record produces the 958 error. Fix the 
> apostrophe and the record is created successfully.
> 
> You can look at the html page source and see the encoding for the bad 
> apostrophe in the form.
> 
> So...even with the UTF encoding, how do I prevent this problem?
> 
> Jonathan