User with accented character in name unable to log in.

[Tony Morosco]

Hi folks,

I have a PHP web/iPhone interface to a table that works great for all users except one user who has an accented é diacritic in his login name.

This user can log into FileMaker app directly without a problem, but the PHP site (set up more or less out of the box) seems to rejects his credentials (error 22).

The PHP script itself is correctly receiving the login data, because when I echo back the variables $userName and $passWord by adding a line to the error message, they are exactly as entered.

I checked the forums and knowledge base for other's problems with extended character problems. I have double checked the home.php script, and it does contain the line in the header that should encode data properly:

I can also verify that the browsers that are used to access the site are using utf-8 character encoding.

So I believe the problem must be the internal handoff of data between the PHP code and FileMaker.

Any ideas on how to troubleshoot this or things to tweak?

Or can anyone report that they are using PHP to successfully authenticate users with accented characters?

Many Thanks,

Tony

[Tony Morosco]

Update:

If I add to the FileMaker-generated PHP code:

     $userName = utf8_decode($userName);

after the 

     $userName = $cgi->get('userName');

Then I can authenticate the user just fine. I of course have to hand code this for all the scripts, in all the tables I am hosting, and re-add it each time I regenerate the site, which is not insubstantial given that we are in active development this summer.

I am now thinking it might be Microsoft's IIS 6.0 butting its head into character encoding somehow, but am unable to find where the default character encoding is specified. The instructions here on how to check IIS character encoding are not applicable. That dialog does not contain "File types..." on our machine.

[Baloo]

Try specifying the charset in a meta tag in the header.

http://fmforums.com/forum/showtopic.php?tid/201486/

[Tony Morosco]

As I detailed in my first post, that is specified in the headers. (comes default with PHP Site Assistant, even.)

[Baloo]

Dough!

Well the only possibly useful piece of data I can add is that the PHP API communicates with Filemaker via a cURL request to the XML feed. You're most likely on the right track with it being an IIS encoding issue. If it's an option you could try putting the Site Assistant code on an Apache server and see what happens

[Tony Morosco]

Wish I had an apache machine option to test. (got one on linux at home, but that's no help!).

Thanks for the pointers, I'll direct some research there.

I've been getting no feedback on FileMaker's own forums on this or other issues.

Is it me, or is customer service slipping precipitously at FM?