On 26 June 2013 22:10, Mateusz Loskot <[email protected]> wrote: > On 25 June 2013 16:58, [email protected] > <[email protected]> wrote: >> Beside the implementation of MSSQL unicode support over std::string I >> stumbled over the unsupported BLOB capabilities of SOCI in terms of ODBC. >> We would use SOCI as replacement ina 3.2M codelines middleware project but >> we have to check carefully all capabilities upfront. >> SOCI is still within the scope (beside other libraries) but after solving >> partly MS unicode things we have to deal with blobs too. >> It's not possible to fetch them over ODBC by vectors, any other way is not >> suiteable because of performance. >> >> So I did some tests to provide BLOB reading/writing using vectors and it >> seems, that it can be handled same straight forward than currently done with >> std::wstring (but with special handling to buffer lazy allocation after >> knowing the real size per BLOB). > > Perhaps, soci::blob would be handy for ODBC, not sure though. > >> I would prefere some more input in terms of BLOB utilization at other >> systems using ODBC prior to define it fix for a 2nd additional base type: >> x_binary (beside the existing x_blob) with a more straight forward class >> wrapping an unsigned char vector as content holder. >> >> I haven't looked yet though the other backends (beside ODBC) but I think, it >> could be handled there more or less similar at the end. >> >> I appreciate any input for BLOB handling to avoid getting a small tunnel >> view :-) > > There have been some discussions about how to support binary streams, > and all discussions led to conclusion that we don't need any additional > container type, just stick to std::string. > > You may find these two threads useful: > > http://soci.6940.n7.nabble.com/SOCI-users-BLOB-for-mysql-backend-td1247.html > > http://soci.6940.n7.nabble.com/soci-users-MySQL-Query-select-round-111100237735-42999-2-td3229.html
Here is another one, where some original decisions background is explained a bit: http://thread.gmane.org/gmane.comp.db.soci.user/909 Best regards, -- Mateusz Loskot, http://mateusz.loskot.net ------------------------------------------------------------------------------ This SF.net email is sponsored by Windows: Build for Windows Store. http://p.sf.net/sfu/windows-dev2dev _______________________________________________ soci-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/soci-users
