3 Replies Latest reply on Jun 24, 2013 8:55 AM by philmodjunk

    PHP ODBC text field request captures only the first 255 characters

    verndemp

      Title

      PHP ODBC text field request captures only the first 255 characters

      Post

           I have read the odbc manual and have installed the FMpro 12 odbc driver that gives me access to turn on describe text fields as long varchar and turned it on , but it still only gives me the first 255 characters. Has anyone found how we can fix this.

           Below- Excerpt from the manual

      Select the Describe text fields as long varchar option to correct issues with long field values, such as fields that do not have a maximum length specified getting used for Microsoft Word Mail Merge import, or field values in PHP applications that are longer than 255 characters. If you do not use this option for field values longer than 255 characters, then your application may retrieve an empty string (Windows) or only 255 characters (Mac OS). 

      Thanks

      Vern Dempster