ODBC Call hangs on long text fields
FileMaker 12 Pro Advanced
Operating system version
Description of the issue
When accessing the FileMaker database via ODBC, a simple query hangs when the targeted field has more than 2047 characters.
Example: Select FirstName, LastName, Signature From Customer
All three fields are TEXT type. Signature contains text data that is greater than 2047 characters. If I run this query on shorter text fields, I get the results I expect. If I run it on fields with values over this limit the query hangs.
Steps to reproduce the problem
Create a simple aspx page with the following code:
<%@ Import Namespace="System.Data.odbc" %>
All text results returned from all fields specified even if the contents are over this 2046 limit.
Any Text fields greater than 2046 characters = hangs query.
All Text fields less than 2046 characters = successful execution