3 Replies Latest reply on Aug 31, 2012 10:38 AM by philmodjunk

    Foreign characters display/encoding issue when inserting/updating via ODBC

    OleMartinJenssen

      Summary

      Foreign characters display/encoding issue when inserting/updating via ODBC

      Product

      FileMaker Pro

      Version

      FM 12.0v2

      Operating system version

      Windows 7

      Description of the issue

      When updating/inserting UTF8 into a Filemaker database using ODBC, foreign characters like "æøå" does not display correctly in Filemaker GUI. The reason seems to be that "raw" UTF-8 is stored into the FileMaker field without being converted, and FileMaker does not know how to display UTF-8.

      Expected result

      Noørdby

      Actual result

      Noørdby

      Exact text of any error message(s) that appear

      none

      Configuration information

      FM ODBC Driver 12.0.79.0
      PHP 5.3.15(Tried both PDO and regular ODBC extension)

      Driver settings:
      * Advanced language set to UTF-8
      * "Describe text fields as long varchar" is checked
      (I've tried all combinations of these settings)

      Workaround

      -

      fm_field_display.png