Thank you very much for this solution. We will try it! :-) 2010/1/11 Sören Meyer-Eppler <[email protected]>
> >>> 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 >
------------------------------------------------------------------------------ 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
