FileMaker mySQL danish characters
In FileMaker Developer 7 I have made some custom functions to connect to mySQL, selecting db's and so on.
I use the SET NAMES utf8 right after selecting a db.
When I run a query selecting rows from mySQL I get odd characters for danish characters (æøå)
When I correct this and do an update of the mySQL table, I get odd characters in the mySQL record
Does anybody know how FileMaker is encoding fields?
Thanks
Jørgen
FileMaker mySQL danish characters
Hi Micah
OK.
I opened the sql query log (encoded mac roman) in bbedit. Danish characters was OK in the log file, but still wrong in mySQL.
I then ran the same queries from FileMaker on Windows and mySQL records was updated with danish characters. The log showed odd charaters, but when reopened as Windows Western Latin1 all characters was correct in the log file as well.
So now this is only a problem on MacIntosh.
FileMaker mySQL danish characters
Hello Jørgen,
I think your issue is being caused by the fact that we can't pass Unicode characters to the PHP engine. As you may know, Unicode support is limited in PHP5 but should be much better in PHP6. We're actively working on this and hope to have a solution before PHP6. We'll be releasing an update when we get this solved so stay tuned.
Regards,
Micah