Foreign Language Characters & CWP

[dcrall]

Hi,

I am migrating an FX.php solution from FM6 to FM7. The site is for the most part in English, but there are many references to foreign museums (e.g. Colecção Vieira Natividade, Portugal).

At one point in my site, I do a search on the database where the museum name is the search parameter. FX encodes the foreign characters in the url, which looks like this:

http://host/fmi/xml/FMPXMLRESULT.xml?-db=database&-lay=web_layout&Location=Colec%E7%E3o+Vieira+Natividade%2C+Portugal&-find

This search worked perfectly in FM6, and it works in FM7 when the museum name doesn't contain foreign characters or if I truncate the search string in front of the first encoded character.

So I'm wondering what's going on? Is this a FileMaker problem? It seems like FX is generating the correct url. Do I have an encoding problem somewhere? My php files are not unicode.

Has anyone seen something similar during a conversion?

Any advice is appreciated. Thank you,

Edited September 29, 2005 by Guest

[mlindal]

you need to use UTF-8 coding on all your files to make this work correctly.

[Garry Claridge]

PHP does not yet support Unicode. However, the 5.5 release is expected to support it.

All the best.

Garry

[mlindal]

so it aint so...

(PHP doesn't support unicode)

On another forum about fx.php I was adviced that all xml format needed to be utf-8 encoded.

So I have the same problem now in that I have a bilingual site with french and english. Entering in the french characters does not transfer to filemaker from the PHP form, but if the french character é for example are input in filemaker, they display correctly when called up.

Any work arounds?

Should I go back to isso 8859-1 ?

[Garry Claridge]

Not having to deal with the characters myself I'm not sure how you would go about handling them.

The PHP website and some PHP forums may be able to shed some light. I will keep my eye on it.

Good Luck.

Garry

[mlindal]

FX.php now has an update to version 4.2 which is supposed to better handle Unicode characters.

iviking.org

but, I still cannot get FX.php to post french characters to Filemaker.

[mlindal]

Here is the answer:

Filemaker 5-6 - use ISO-8559 coding

Filemaker 7+ - use UTF-8 coding

I tested and this works.

However as an interesting sidenote - filemaker 6 mentions that it supports UTF-8 when importing xml, so it may be related to the web companion and not filemaker.