On 18 February 2013 09:29, lk <[email protected]> wrote:
> mloskot wrote
>>> 10. Does SOCI support CLob/Text types?
>>
>> CLOB (i.e. SQLT_CLOB type in Oracle) is not supported, but has been
>> been on TODO list for long time :)
>
> How difficult would it be to add such support for Oracle?
I don't have extensive experience with Oracle and OCI library
(I almost solely work with PostgreSQL)
So, it is difficult to tell.
It may be as easy as replicating how SQLT_STR support is implemented
(see src/backends/oracle/standard-{into|use}-type.cpp), and handle CLOBs
as plain text data, with (I guess) UTF-8 character semantic.
Or, enable use of soci::blob for SQLT_CLOB data, by adding x_clob with
corresponding implementation cases, then CLOB is handled as a sequence of
bytes, but then we loose character semantic, so we may need to add some
encoding-related interface to soci::blob or impose CLOB in soci::blob
is always UTF-8
(actually, that would be similar to std::string option above).
Or, it may be reasonable to add new soci::clob interface with corresponding
details::cblob_backend, so the characters semantic is handled in flexible way.
I haven't thought through CLOB support thoroughly, so I'm just
brainstorming here.
So, CLOB experts wanted!
Best regards,
--
Mateusz Loskot, http://mateusz.loskot.net
------------------------------------------------------------------------------
The Go Parallel Website, sponsored by Intel - in partnership with Geeknet,
is your hub for all things parallel software development, from weekly thought
leadership blogs to news, videos, case studies, tutorials, tech docs,
whitepapers, evaluation guides, and opinion stories. Check out the most
recent posts - join the conversation now. http://goparallel.sourceforge.net/
_______________________________________________
soci-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/soci-users
