Summary:ASTERISK-16443: Not more than 256 character can be returned from column data
Reporter:R.E. van Leyden (vanleyden)Labels:
Date Opened:2010-07-27 11:11:36Date Closed:2010-08-03 10:34:14
Versions:Frequency of
Description:When a query is done and the returning value is more than 256 characters long the returning value is truncated to 256 characters.


When changing the value on line 327 from the source func_odbc.c  coldata[256] to coldata[2048] the problem is solved. The maximum returning value of a column in MySQL is 2048, so when this is changed it will mach the length.

Is it possible to add this to the new version ?
Comments:By: Tilghman Lesher (tilghman) 2010-08-03 10:22:40

Uh, what column type in MySQL has a maximum of 2048?

By: Tilghman Lesher (tilghman) 2010-08-03 10:34:14

Specifically, varchar now has a maximum limit of 65535 characters, as does smalltext.

This is not something that I can fix generically in 1.4, as altering the size of stack buffers may influence how existing dialplans work.  However, this should not be a problem in 1.6.2 and later versions, as the buffer size is dynamically calculated based upon the dataset.

While you are certainly welcome to make this manual change in your own copy of 1.4, it will not be in an official version.  I would encourage you to upgrade, if you want variable length column data.