[FX.php List] Foreign characters in CWP request

[Dennis Crall]

Hi,

I posted this last week, but I've documented the problem in more detail. I'm
hoping someone can at least comment on the level of "Yeah, we're doing that
and it should work" or "We've seen this problem also." Any input is
appreciated.

Thanks for your time,

Dennis Crall
ITS-Academic Technologies
The University of Iowa
http://at.its.uiowa.edu
 
-------------------------------------------------------

Background:
We have a FileMaker 6 custom web publishing solution that needs to be
migrated to FileMaker 7. CWP requests are generated from FX.php. The
solution is in English but deals with archaeological artifacts from Spain
and Portugal. As a result, the site includes many names that contain foreign
characters. 

Use case:
The user can browse the site based on the museums, which house the
artifacts. The web site generates a list of museums from a fixed value list.
Each museum name is a link, which should perform a simple find query for the
plaques housed in that museum.

Problem:
The search does not work in FileMaker 7 when the museum name includes
foreign characters. The search operates normally if the museum name contains
no characters that need to be url encoded. The search operates normally from
the FileMaker 7 client interface. This behavior is consistent with other
fields containing similar values.

CWP Request Details:

FM6, FM7 PHP request:
search.php?museum=Associa%E7%E3o%20Local%20de%20Arte%20e%20Arqueologia%20de%
20Rio%20de%20Moinhos,%20Portugal
  
search.php?museum=Associa%E7%E3o%20Local%20de%20Arte%20e%20Arqueologia%20de%
20Rio%20de%20Moinhos,%20Portugal


The FM7 CWP request returns an error code of -1:
http://fm7/fmi/xml/FMPXMLRESULT.xml?-db=esprit&-lay=web_search&Location=Asso
cia%E7%E3o%20Local%20de%20Arte%20e%20Arqueologia%20de%20Rio%20de%20Moinhos%2
C%20Portugal&-find


This next FM7 CWP request returns successfully once the search string is
truncated before the encoded characters:
http://fm7/fmi/xml/FMPXMLRESULT.xml?-db=esprit&-lay=web_search&Location=Asso
cia&-find 


Surprisingly, this request which truncates the search immediately after the
first foreign characters also returns successfully. If the next character in
the search string, "o",  is added though (either normally or encoded), we
see the -1 error code.
http://itsnt206.iowa.uiowa.edu/fmi/xml/FMPXMLRESULT.xml?-db=esprit&-lay=web_
search&Location=Associa%E7%E3&-find
 

The FM6 request, which returns successfully:
http://fm6/FMPro?-db=slate_.fp5&-lay=Layout%20%231&-format=-fmp_xml&Location
=Associa%E7%E3o%20Local%20de%20Arte%20e%20Arqueologia%20de%20Rio%20de%20Moin
hos%2C%20Portugal&-find


Comparing the two CWP requests for the Location field (FM6, FM7):
Location=Associa%E7%E3o+Local+de+Arte+e+Arqueologia+de+Rio+de+Moinhos%2C+Por
tugal&-find        
Location=Associa%E7%E3o+Local+de+Arte+e+Arqueologia+de+Rio+de+Moinhos%2C+Por
tugal&-find