HOW TO insert binary data into IMAGE column using db-lib
LacaK <[email protected]>
| Newsgroups | gmane.comp.db.tds.freetds |
|---|---|
| Message-ID | <[email protected]> |
Hi, excuse me for another question. Now I catch problem with sending sql INSERT statement with binary data > 4KB I use dbcmd + dbsqlexec (because AFAIK db-lib does not support parameter binding only result columns binding) ATM I send sql command like this: "insert into table1 (col1, image_col) values(1, 0x...)" but only first 4096 bytes are writen into image column ? Is there any way how to solve this (how to send full length binary data)? (Only way which I can see is on the fly create temporary stored procedure with one insert statement and then use : dbrpcinit + dbrpcparam + dbrpcexec) I know, that there is family of db-lib functions, which works with IMAGE/TEXT data, but they require "text or image pointer", which is unknown at insertion time. Are there any plans for extending db-lib to support parameter binding for sql statements (something like ODBC has)? TIA -Laco. _______________________________________________ FreeTDS mailing list [email protected] http://lists.ibiblio.org/mailman/listinfo/freetds