[unixODBC-support] Character limit using select query?

Nick Gorham nick.gorham at easysoft.com
Fri Jul 18 09:18:54 BST 2008

Alexander Medina wrote:

>Hi Everyone;
>I have a pretty basic issue:
>My setup is that I am using unixODBC with freetds and psql drivers to
>interact with two different databases (SQL Server, and PostgreSQL).
> Occasionally one of the fields I run a select query on is sometimes over
>1000 characters, and the query will not return any values.  I can run the
>query via other means such as a database manager and successfully return the
>values, just not using the unixodbc connection.  I have tested using the
>isql program, and still receive the same issue.   The same query works fine
>when the values aren't as long.
>Essentially I would have a cron job running a perl script executing this
>query, utilizing unixODBC.  Are there known issues with character limits on
>returned select queries?  If so, is there a setting to change or other
>solution?  If there are no known issues, any ideas out there on what could
>be causing the problem?
>Thanks in advance!
>Alex Medina
Maybe turn on tracing and see if the data is returned. There are no 
limits in the driver manager, and as far as I now the driver. isql won;t 
display blobs, but thats by design, other than that I would check the 
app you are using.

Nick Gorham
Easysoft Limited
http://www.easysoft.com, http://www.unixODBC.org

More information about the unixODBC-support mailing list