Date and swedish letters

[Mattias R]

I made a solution in Filemaker 6 Unlimited with Apache and FX.php. The datefield in the database was yyyy-mm-dd and was published in that way on the website.

Now I have upgraded the database to Filemaker 8 and are using FMSA 8 with IIS and FX.php and the date is still yyyy-mm-dd in the database but are published on the website as mm/dd/yyyy.

I thought first the problem was that the server that I tested the upgraded solution had an english OS but when I tested it on a machine with swedish OS, the problem was still there.

made a query to the database with the datefield (format yyyy-mm-dd) and with 1 matching record just to see what it would return.

$query_sjuk_search = new FX($serverIP, $port);

$query_sjuk_search -> SetDBData ($database,'franvaro_webb','all');

$query_sjuk_search -> SetDBPassword($webpassword,$webusername);

$query_sjuk_search -> AddDBParam ('personnummer', '999999-0001');

$query_sjuk_search -> AddDBParam ('datum', '2006-01-19');

$resultat_sjuk_search = $query_sjuk_search -> FMFind();

But when I echo the result I get 0 matching record?

I tried to post another query to the database to another field in the same database in Filemaker that use a valuelist with some specified values.

When the specified values contains swedish letters (å, ä and ö) I got 0 matching records (for example SJUKANMÄLD).

When I search in the same field on values that doesn't contain the swedish letters I got matching records (for example LEDIGHET).

When I make a search to get all the records and show them on the website the swedish letters are presented correct.

So what to do?

[Helleshoj]

Maybe a bit late, but I do work with similar problems at the moment. So far as I can see, the coding of these special characters is different, depending on the way they "go". "