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 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
