[FX.php List] Bad apostrophe character confounds FMP

Sun Dec 9 23:57:15 MST 2007

Jonathan,

There are probably lots of causes, but every time I've seen this it's because the php page file didn't have this in the head:

<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>...

...or if it did have that, it wasn't saved actually using the UTF-8 encoding.

For FX PHP use, it's GOT to be UTF-8.

-Troy

> Hi Folks,
> 
> I spent a bunch of time diagnosing a 958 error that was eventually 
> narrowed down to a character in the name "O'Doherty".  The  application
> loads an existing FMP record into a session, allows  editing and then
> creates a new record based on the eited data.  The  apostrophe appeared
> as "%92" in the FMP query, and caused the 958  error during new record
> creation..  I have no idea how 958 relates,  but it was definitely the
> culprit.
> 
> The question is, what techniques do you us to condition data,  a 
> regexp? and on every field?
> 
> Thx.
> 
> Jonathan