[unixODBC-support] Re: unixODBC-support Digest, Vol 41, Issue 9

9 9 at slagboomscat.com
Mon Jan 21 13:41:20 GMT 2008

9 wrote:

>>Hi all,
>>I'm running unixodbc 2.2.11 on CentOS 4, with both the mysql and freetds drivers, and DSNs to both MySQL and MSSQL databases.
>>When querying a MySQL or MSSQL database using isql, it appears that VARCHAR columns that contain data greater than 300 characters are being returned as null.
>>For example:
>>$echo "select textdescription from issues" | isql -b dsn user pass
>>| textdescription                                                          |
>>|                                                                                   |
>>However, when the textdescription field has content of 300 characters or less, the content is displayed as expected.
>>I attempted isql with -m500 to allow for larger data content to be returned, but it didn't change the symptom.  
>>Is there something that drives this limit tha
>>unixODBC-support mailing list
>>unixODBC-support at easysoft.com
>Edit exe/isql.h in the source tree and increase
>#define MAX_DATA_WIDTH 300
>Remember that isql is only a test app, so its not attempting to cover 
>all usages.
>Nick Gorham
>Easysoft Limited
>http://www.easysoft.com, http://www.unixODBC.org


Thanks for the info.  Sorry for such a noob question, but:  Other than isql, is there a tool that you'd recommend using from shell script to execute queries?



unixODBC-support mailing list
unixODBC-support at easysoft.com

End of unixODBC-support Digest, Vol 41, Issue 9
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.unixodbc.org/pipermail/unixodbc-support/attachments/20080121/6149391a/attachment.html>

More information about the unixODBC-support mailing list