Dan... Yes the varint! --- On Mon, 5/4/09, Dan <danielk1...@gmail.com> wrote:
> From: Dan <danielk1...@gmail.com> > Subject: Re: [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: Monday, May 4, 2009, 11:52 PM > > 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 > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users