2 Replies Latest reply on Nov 14, 2011 6:19 PM by Michael Frankel

    How to Matching ODBC type with Filemaker field type

    user14040

      I am trying to create a solution that will store the data on the internet. My problem is with matching the fields with my mysql database.

       

      What is the file type for a container field?

      Will the Container field work using ODBC? I want to use it for signatures and storing files like PDF's

       

       

      What is File Type for a Global Field?

      Do I use Decimal field type

       

      mysql Field Types I use if the one i should use is not listed please let me know

       

      Int

      Double

      Decimal

      Date

      Datetime

      Time

      Varchar

      National Varchar

      Tinyint

      MediumText

      MediumBlob

       

      Attached is my table Fields that is using ODBC the container fields for the signature and PDF attachment is not listed because I dont know what field type to use.

       

      thanks