Perhaps a simpler question ?
Is it actually possible, using the xDBC drivers to connect to FileMaker and do a search on a database field that will contain special characters (German language mostly, but also French, Swedish etc.)?
Like this :
SELECT * FROM Terminology where Acronym='Ö%'
And I have these values in my database for Acronym :
I have tried DSN connection, DSN-less connection, using advanced language in the driver : auto, and then UTF-8 and my query cannot locate these entries - returns an empty set.
The user of the database can search from within FileMaker and finds these 3 entries.
Is it actually possible to search for special characters using the FileMaker 11.3.81 xDBC driver ?
I ran a test using my code to connect to a MySQL database and it searches fields that contain special characters with no problem at all.
Any feedback greatly received.
OK, I found a solution.
In my PHP files (which I saved as UTF-8) I had these statements at the top :
header('Content-Type: text/html; charset=UTF-8');
I was trying to keep all my working in UTF-8.
The trick I found was to actually submit the SQL string to FileMaker as ISO-8859-1 as below !
$sql = mb_convert_encoding($sql , "ISO-8859-1"); // Convert the SQL string being sent to Filemaker.
$rs=odbc_exec($conn,$sql); // Execute the SQL to FileMaker
And this was leaving the driver's advanced language settings set to UTF-8.
Hope this may prove useful to anyone else who runs into the nightmare that is encoding.