AnsweredAssumed Answered

PHP ODBC text field request captures only the first 255 characters

Question asked by verndemp on Jun 21, 2013
Latest reply on Jun 24, 2013 by philmodjunk

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

      

Outcomes