On 26 March 2014 13:03, Andrew Grafham <[email protected]> wrote:
> On 21 March 2014 09:54, Mateusz Łoskot <[email protected]> wrote: > >> On 19 March 2014 12:59, Andrew Grafham <[email protected]> wrote: >> > Hi, >> > >> > Should reading a Clob/Text field into a vector work in Soci 3.2.2 with >> ODBC >> > connecting to SQL server? I'm compiling using visual studio 2013 and >> MingW, >> > and the code crashes with both. >> > >> > If I change the SQL to cast the Clob field to a Varchar, the problem >> goes >> > away, and the code works fine with MySQL. >> >> Andrews, >> >> AFAIR, CLOB support is not available, it's been on TODO list for quite >> a long time now. >> >> Best regards, >> -- >> Mateusz Łoskot, http://mateusz.loskot.net > > > Thanks. I guess it's just by luck that it works on MySQL then? > > I've come across another quirk - I'm doing vector inserts now, and I can > "use" a std::vector<boost::optional<boost::gregorian::date> > for > inserting, and that works fine, but if I try > std::vector<boost::optional<std::string> > , that doesn't seem to work (the > value inserted is always NULL, and there are definitely values populated > into the vector. Is that another known limitation? > > Thanks > > Andy > > > I've played around with this a bit more, and inserting a vector of strings using boost::optional seems to work on MySQL but not Oracle. I'm working around it for the moment by using boost optional for everything other than strings, where I use a separate soci::indicator vector). Cheers Andy
------------------------------------------------------------------------------
_______________________________________________ soci-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/soci-users
