[FX.php List] French and not only characters

[Joel Shapiro]

Good memory / educated guess, Andy ;-)  Dale's post of this saved me  
a lot of grief too.  And good advice to put this on all submission  
pages.

FYI to others: there are apparently different charset requirements  
based on the FMServer/Unlimited version:

> FM7SA  FM8SA
> <meta http-equiv="content-type" content="text/html; charset=UTF-8">
>
> FM5-6U US
> <meta http-equiv="content-type" content="text/html;  
> charset=iso-8859-1">
>
> FM5-6U EU
> <meta http-equiv="content-type" content="text/html;  
> charset=iso-8859-15">

Best,
-Joel


On May 11, 2006, at 3:55 PM, Andy Gaunt wrote:

> Dana,
>
> It is wise to encode your php pages that submit data to the  
> database with
> the UTF-8.
>
> Trust me, it is not just foreign characters that can cause a  
> problem. I had
> this issue on a page I did not encode when someone was copying and  
> pasting
> from word. The word 'oddities' characters played the same 958 error  
> with me
> (yet I was getting the emails with the full posted information).
>
> Drove me nuts till I remembered the email that someone referenced  
> here with
> the different meta tags. I think it was Dan, Dale, Kevin...oh who am I
> kidding. I don't remember who it was but a useful reference it was.
>
> Place the following at the top of your pages.
>
> <meta http-equiv="content-type" content="text/html; charset=UTF-8">
>
> This should also alleviate any issues with the square box syndrome
> occasionally seen with multi line text fields.
>
> Andy Gaunt
> T: 407.810.4722
> andy at fmpug.com
> http://www.fmpug.com
>
> Recipient of FileMaker’s 2005 “Mad Dog” Public Relations Award
>
> For chapter locations, dates & times please visit the website at
> http://www.fmpug.com If you can make it to a meeting, please RSVP at
> http://www.fmpug.com/rsvp.php
>
>
> -----Original Message-----
> From: fx.php_list-bounces at mail.iviking.org
> [mailto:fx.php_list-bounces at mail.iviking.org] On Behalf Of Dana Benciu
> Sent: Thursday, May 11, 2006 10:22 AM
> To: adenman at tmea.org; FX.php Discussion List
> Subject: Re: [FX.php List] French and not only characters
>
> Hi Andrew,
>
> I tried what you are saying and ... actually I think I have problems
> even with characters like "’" (the very inclined apostrophe) ...
>
> I think Andre is right with the charset utf-8 ... Yes, this only  
> happens
> with these characters and unfortunately my tests from before did not
> include such characters so that's why the info got into the  
> database and
> I didn't see any error ...
>
> Dana.
>
> Andrew Denman wrote:
>> Let's try that again...
>>
>> According to my documentation:
>> "958" => "Parameter missing in query"
>>
>> Make sure the rest of your query is built correctly.  You can  
>> check the
> URL
>> FX.php is sending to FileMaker by putting this on the page after  
>> you send
>> the query (paste the link that comes from this into your next reply):
>> print_r($ReturnedData['URL']);
>>
>> Does this only happen when you try to enter text with these special
>> characters?
>>
>> Andrew Denman
>>
>> -----Original Message-----
>> From: fx.php_list-bounces at mail.iviking.org
>> [mailto:fx.php_list-bounces at mail.iviking.org] On Behalf Of Dana  
>> Benciu
>> Sent: Wednesday, May 10, 2006 7:02 PM
>> To: FX.php Discussion List
>> Subject: [FX.php List] French and not only characters
>>
>> Hello everyone,
>>
>> I am trying to insert some characters in a FM 7 database like "°"  
>> using
>> the FX.php package and I am getting the error #958 and the  
>> information
>> is not recorded. If anybody can give some useful advices/ideas, that
>> would be much appreciated!
>>
>> Thanks a lot,
>> Dana.
>>
>> _______________________________________________
>> FX.php_List mailing list
>> FX.php_List at mail.iviking.org
>> http://www.iviking.org/mailman/listinfo/fx.php_list
>>
>>
>>
>>
>>
>>
>>
>> _______________________________________________
>> FX.php_List mailing list
>> FX.php_List at mail.iviking.org
>> http://www.iviking.org/mailman/listinfo/fx.php_list
>>
>
>
> -- 
> Dana Benciu
> Web and IT Coordinator
> Association for Women's Rights in Development (AWID)
> 215 Spadina Avenue, Suite 150
> Toronto, Ontario Canada M5T 2C7
> tel: (+1) 416-594-3773 fax: (+1) 416-594-0330
> dbenciu at awid.org  --- http://www.awid.org
>
>
> _______________________________________________
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
> http://www.iviking.org/mailman/listinfo/fx.php_list
>
>
> _______________________________________________
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
> http://www.iviking.org/mailman/listinfo/fx.php_list