On Wednesday 24 February 2010 22:34:02 [email protected] wrote: > Thanks Aleksander. > > My problem is that I want to insert/retrieve binary data into a SQL table > without the need to discriminate different backends. > We want to be able to feed data into mysql and postgres (and possibly > sqlite3 as well) in a uniform way. > > I have a posgresql table like this > > create table foo ( > id INTEGER, > buffer BYTEA, > ); > > and a mysql table like this > > create table foo ( > id INTEGER, > buffer LONGBLOB, > );
Just a side note, AFAIK, postgresql backend in soci supports large objects, not bytea. -- Regards Shridhar ------------------------------------------------------------------------------ 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 _______________________________________________ Soci-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/soci-users
