I am new at the company where I work. It is a publishing company.
I know very little about FileMaker.
Here is the situation. The company has an old FileMaker database that was set up during the 1990s. The editorial staff loves the FileMaker database. Or, rather, they are used to it. They interview people, and somehow input the text of the interviews into FileMaker.
Elsewhere in the company, there is an art/design staff that pulls data from FileMaker, and they turn this into the monthly magazine.
I am working with the tech team that enables the web site. The website works with a MySql database, and runs using PHP. Here is how things are handled:
1.) Export content from FileMaker to some text format.
2.) Run lots of scripts on the text format, to make it ready for the web.
3.) Import the text content to MySql, so it can be seen on the web.
I would like to reduce the work in step #2. Apparently the FileMaker database is set up to hold latin characters. The website is UTF8. In step #2, we convert some of the latin characters to UTF8.
Now, I am wondering why FileMaker can not be changed to allow the text to be entered as UTF8 in the first place. If this was MySql, this would be trivially easy. I am wondering if this is also trivially easy with FileMaker? Could someone tell me something about how FileMaker manages the character encoding of its fields?
