On May 4, 2009, at 10:14 PM, Ken wrote: > > You could just pass the sqlite3_int64 value. It is portable between > systems. Search through the sqlite3 code and there are routines that > do the conversions from the sqlite3_int64 to a native int64 type. > They basically perform bit shifting and will be much faster than the > string conversions.
You're thinking of the varint format used in the file-format: http://www.sqlite.org/fileformat.html#varint_format sqlite3_int64 is just a typdef of int64_t on most platforms. Dan. > > > HTH, > Ken > > --- On Sun, 5/3/09, Sam Carleton <scarle...@miltonstreet.com> wrote: > >> From: Sam Carleton <scarle...@miltonstreet.com> >> Subject: [sqlite] OT: how best to convert sqlite3_int64 to and from >> string in a cross platform fashion? >> To: "General Discussion of SQLite Database" <sqlite-users@sqlite.org> >> Date: Sunday, May 3, 2009, 4:21 PM >> I am current developing a system only >> on Windows, but I do plan to port it >> to OSX someday. I am passing ID's as strings to keep >> maximum flexibility >> between databases and the existing system. So how do >> I convert a >> sqlite3_int64 to a string and a string to a sqlite3_int64 >> in a cross >> platform fashion? >> >> Sam >> _______________________________________________ >> sqlite-users mailing list >> sqlite-users@sqlite.org >> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users >> > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users