[FX.php List] Re: FX.php_List Digest, Vol 26, Issue 24

[Lindal, Mark]

I think I fixed the coding issue.  My Apache version 2.2 has set UTF-8 as
the default character set so eventhough my pages has specified ISO-8559-1,
apache was overruling this and changing the pages to UTF-8.

But 2 points

- good idea about the UTF-8 decode that may work if I can figure out how to
test for it.
- as well I think that in the FX.php library there may be a way of handling
the "case fmpro5/6" situation right there and send the coding with
iso-8559-1 since we know this is required for fmpro 6.

And sometime within the next 2 years we may be able to convert to version 8
and solve the problem.  Until then, I will have to work with the hand I am
dealt.


> ------------------------------
> 
> Message: 6
> Date: Fri, 15 Sep 2006 12:00:53 -0700
> From: "William Akey" <wcakey at hotmail.com>
> Subject: Re: [FX.php List] Re: FX.php_List Digest, Vol 26, Issue 23
> To: "FX.php Discussion List" <fx.php_list at mail.iviking.org>
> Message-ID: <BAY119-DAV8DE9E14923CA444C77600CD2E0 at phx.gbl>
> Content-Type: text/plain; charset="iso-8859-1"
> 
> Hi Mark,
> 
> Don't know if this will help, but  in addition to the utf8_encode()
> function
> in PHP, there is also a utf8_decode function. Now, if you had a way to
> determine that the posted info was utf-8 encoded, you could apply the
> decode
> function and be on your way.
> 
> Hope this helps
> 
> William
> 
> 
> ----- Original Message -----
> From: "Lindal, Mark" <mlindal at pfc.forestry.ca>
> To: <fx.php_list at mail.iviking.org>
> Sent: Friday, September 15, 2006 11:41 AM
> Subject: [FX.php List] Re: FX.php_List Digest, Vol 26, Issue 23
> 
> 
> This is an advanced topic and I need some help to sort our character
> encoding for fm5/6 data.
> 
> This is centered around iso-8559-1 vs utf-8
> 
> To send data successfully to an FM5/6 database requires iso-8559-1
> encoding.
> 
> Example:  when creating a new record [FMNew() ] Québec is entered into
> the
> filemaker database as Qu at A#5bec if the encoding is UTF-8.  When the
> encoding
> is iso-8559-1 Québec is entered as Québec.
> 
> Now the question:
> 
> If a person with a browser set to default coding UTF-8 override my page
> settings (ISO-8559-1) and still enter garbage characters into the
> database?
> 
> I tested with Safari set to UTF-8 and it did override my page settings.
> 
> So now to the guts:  é = %E9 under iso-8559-1 and %C3%A9 under UTF-8
> 
> In other words: How can I fix the URL string FX.php creates to be ISO
> characters in these cases.
> 
> An example URL string
> 
> http://FX:password@host:591/FMPro?-db=database.fp5&-lay=web&-format=-fmp
> _xml
> &province=Qu%E9bec&-edit
> 
> In FX.php there are xml_parser and ExecuteQuery () and Characterencoding
> that may need to be tweaked - but I need to know which functions might
> need
> to be tweaked so this clears the data.
> 
> This may be a minor bug in FX.php for case='fmpro5/6' that needs to be
> looked at.
> 
>> 
>> While I can't vouch for the veracity of the first part above, I can
> say
>> that
>> I use ISO-8859-1 everyday with FMSA8. Having said that, I really
>> *should* be
>> using UTF-8, but we still have a mixed FMU6/FMSA8 environment at the
>> moment.


> ------------------------------
> 
> Message: 8
> Date: Sat, 16 Sep 2006 10:07:07 +0200
> From: "Gjermund Gusland Thorsen" <ggt667 at gmail.com>
> Subject: Re: Re: [FX.php List] Re: FX.php_List Digest, Vol 26, Issue
> 20
> To: "FX.php Discussion List" <fx.php_list at mail.iviking.org>
> Message-ID:
> <e6ecb7940609160107l7637620fi1d6e46766ec2114e at mail.gmail.com>
> Content-Type: text/plain; charset=ISO-8859-1; format=flowed
> 
> As long as you do not use characters outside the ASCII space of 0x20
> to 0x7f I believe it is character encoding does not really matter.
> 
> Perhaps all the way to 0x9f works, but I'm not sure
> 
> ggt667
> 

------------------------------
Mark Lindal
Publications Technician  / Technicien, publications
Canadian Forest Service  / Service canadien des forêts
Natural Resources Canada / Ressources naturelles Canada
Government of Canada     / Gouvernement du Canada
506 West Burnside Road   / 506, chemin Burnside ouest
Victoria, BC V8Z 1M5     / Victoria (C.-B.) V8Z 1M5

mlindal at pfc.forestry.ca
250-363-0603