GitHub user CurtHagenlocher added a comment to the discussion: Discussion: ODBC 
adapter driver for ADBC

One thing to be aware of for multi-row binding is that you generally need to 
preallocate enough space to hold the maximum-sized values for a particular 
column. This becomes problematic when the table has IMAGE or TEXT columns with 
a very large upper bound on the size. Single-row binding is usually okay, 
because you can bind a smaller buffer and then fetch that entire value 
explicitly with `SQLGetData` when there's an overflow. But this doesn't usually 
work for multi-row binding because most drivers don't let you go back and do 
`SQLGetData` against a previous row -- you need (IIRC) a local cursor for that.

GitHub link: 
https://github.com/apache/arrow-adbc/discussions/4205#discussioncomment-16545277

----
This is an automatically sent email for [email protected].
To unsubscribe, please send an email to: [email protected]

Reply via email to