Koen, > But, according to the MySQL C Api information, you an also ask what is > the maximum size for each result field given the statement itself ? > > MYSQL_STMT *stmt = ... > res = mysql_stmt_result_metadata(stmt) > field = mysql_fetch_field(res) > field->max_length
> Would that not work ? I knew about max_length.... But if you changed the create statement with "varchar" and not "text", then things might change. However I had the impression that even if you define varchar(200) max_length will retrieve the max varchar that is 65,535. I will check this again. But if for varchar(200) it will retrieve the varchar(200) size that is 200, then both the MySql and me, we are happy :) > Postgres allocates the memory for the result itself. This is good and bad... Especially if you want to have control over the allocation... For example if you want to use memory pool for your thread :) Conclusion: 1. I will check if max_length in case of varchar(X) will retrieve X, and if yes, then issue can be closed... -- rgrds, mobi phil being mobile, but including technology http://mobiphil.com ------------------------------------------------------------------------------ Download Intel® Parallel Studio Eval Try the new software tools for yourself. Speed compiling, find bugs proactively, and fine-tune applications for parallel performance. See why Intel Parallel Studio got high marks during beta. http://p.sf.net/sfu/intel-sw-dev _______________________________________________ witty-interest mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/witty-interest
