Re: [sqlite] datetime column type, how-to

[EMAIL PROTECTED] wrote: SQLiters: What would be the best method for creating a Table with one column in the format 03-Mar-2005 16:05:30? i.e. dd-mmm-yy hh:mm:ss I would store the date in UNIX timestamp format. I will need to retrieve by date/time in proper order. i.e. "select * from 'table'

Re: [sqlite] Windows Unicode Support

D. Richard Hipp wrote: On Sun, 2005-02-13 at 16:18 -0600, Jeff Thompson wrote: sqlite3_exec sqlite3_mprintf I was wondering why there are no unicode versions of these (and possibly others) functions? sqlite3_exec is implemented in using other published APIs. It is a convenience wrapper

[sqlite] Windows Unicode Support

Hi, I've recently gone through the work to convert my windows application to unicode. A ran across a couple of the sqlite3 API calls that don't seem to have unicode versions, namely: sqlite3_exec sqlite3_mprintf I switched all of my sqlite3_mprintf/sqlite3_exec calls to

Re: [sqlite] sqlite thread safe builds

y of the thread safe status of sqlite3 while being built with MSVC under windows. Thanks, -- Jeff Thompson / /

Re: [sqlite] compiled features at runtime?

e: #if defined(THREADSAFE) && THREADSAFE int g_isThreadSafe = 1; #else int g_isThreadSafe = 0; #endif and then check g_isThreadSafe in your code at run-time. Hope that helps. -- Jeff Thompson

Re: [sqlite] compiled features at runtime? - Re: [sqlite] still struggling with "Database schema has changed" errors

EADSAFE int g_isThreadSafe = 1; #else int g_isThreadSafe = 0; #endif and then check g_isThreadSafe in your code at run-time. Hope that helps. -- Jeff Thompson [EMAIL PROTECTED]

[sqlite] sqlite thread safe builds

s being built correctly for my project. Since the patch checks for the _MSC_VER macro, it would only affect windows builds, using Microsoft's compilers. There may be similar methods for Borland, Intel, etc., but I'm afraid that I'm only familiar with MS's compilers. Thanks, -- Jeff Thompson [EMAIL PROTECTED]

Re: [sqlite] bogus output for strftime('%s', 'now')

reader.getstring(0) returns a std::string, try the following: cout << reader.getcolname(0) << ": " << reader.getstring(0).c_str() << endl; -- Jeff Thompson [EMAIL PROTECTED]

Re: [sqlite] wchar for sqlite prolem

the > sqlite only take char for parameters. Do anyone know how to store unicode > (such as chinese, japanese) in sqlite. I am using visual studio 2003 and > windows 2000 OS. > > Thank you in advance. > > Ming > -- Jeff Thompson [EMAIL PROTECTED]