>>> Is there a way to work with columns of type bytea in PostgreSQL?
>> No, this type is (currently) not natively supported, although
casting to
>> text might be a possible way to go for the time being - but I did not
>> try this personally.
That's what I'm currently doing in Postgres.
insert into "table" ( "byteaColumn" ) values ( decode(
'yourHexEncodedStringGoesHere', 'hex' ));
select encode( "byteaColumn", 'hex' ) from "table";
Works. Although skipping the extra encoding step (which blows up
every byte to two) would be cool of course.
BTW, I had to patch std::wstring support into SOCI for supporting
Postgres multibyte UTF strings. Any chance to get Unicode support in
the official version?
cheers,
Sören
--
Sören Meyer-Eppler
software developer
[email protected]
http://www.BuschnicK.net
------------------------------------------------------------------------------
This SF.Net email is sponsored by the Verizon Developer Community
Take advantage of Verizon's best-in-class app development support
A streamlined, 14 day to market process makes app distribution fast and easy
Join now and get one step closer to millions of Verizon customers
http://p.sf.net/sfu/verizon-dev2dev
_______________________________________________
Soci-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/soci-users
