Hi All,
I am new here and would like to learn on how to do Case Insensitive
comparison of Double Byte Characters?
Thanks in advance.
Alex
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Evan Burkitt wrote:
> Maybe a way of making the sqlite3 shell treat these fields as BLOBS,
select cast(column as blob)
You have the full source to the shell and can change the text printing
routine to do whatever you want (hex output, html style es
I have some tables which are maintained programmatically, and which have a text
field in which I store a block of text made up of a series of null-separated
strings. I am able to read and write these fields through the program without
problem; reading via sqlite3_column_text() and sqlite3_column
D. Richard Hipp wrote:
>
> CREATE TABLE whatever(
>
> timestamp DATE DEFAULT (datetime('now','localtime')),
> ...
> );
>
Really? I can do that? Great!
Thanks!
--
View this message in context:
http://www.nabble.com/CURRENT_DATE-Behavior-tp20075044p20082173.html
Sent from
On Oct 20, 2008, at 1:46 PM, jonwood wrote:
>
> Greetings,
>
> Okay, I understand that the designer of SQLite felt it was important
> that
> fields with a default value of CURRENT_DATE should be initialized to
> the
> current date in a DIFFERENT time zone. Setting aside for now that
> I've
On Mon, 20 Oct 2008 18:01:03 + (UTC), MikeW
<[EMAIL PROTECTED]> wrote:
>Still, I would like to be able to run the Transaction over these two calls ...
>What's the best way, given I have two separate handles ?
>Make them separate Transactions and do a ROLLBACK on the first if the
>second exec
MikeW <[EMAIL PROTECTED]> wrote:
> I presume I'm not allowed to do this:
>
> // apply updates on first db - start Transaction
> ret = sqlite3_exec(
>first_db,
>"BEGIN; UPDATE " FIRST_DB_TABLE
>" SET " FIRST_DB_COLUMN "=1 "
>
yokk y <[EMAIL PROTECTED]> wrote:
> -
> ID NAME
> ==
> (1)1 AA
> (2)3 CC
> (3)4 DD
> (4)6
yokk y <[EMAIL PROTECTED]> wrote:
> -
> ID NAME
> ==
> (1)1 AA
> (2)3 CC
> (3)4 DD
> (4)6
I've got a database file that somehow got corrupted. This is a dev system
so I'm not overly concerned, but if the SQLite team would like to take a
look you can. I'm using 3.5.6 on Windows.I'm using PRAGMA
SYNCHRONOUS=1, so I'm not quite sure how this happened.
Sqlite3_analyzer crashes imm
On Mon, 20 Oct 2008 10:46:41 -0700 (PDT), jonwood
<[EMAIL PROTECTED]> wrote in General Discussion of SQLite
Database :
>
>Greetings,
>
>Okay, I understand that the designer of SQLite felt it was important that
>fields with a default value of CURRENT_DATE should be initialized to the
>current date
On Mon, 20 Oct 2008 12:38:29 +0200, jm cuaz <[EMAIL PROTECTED]> wrote
in General Discussion of SQLite Database :
>Hello,
>
>We try to port an application specialised in financial calculus written
>in VBA + MS Access toward Tcl + Sqlite.
>
>In this application, 90% of the calculus is directly proc
On Mon, 20 Oct 2008 12:26:33 +0530, "Rajesh Nair"
<[EMAIL PROTECTED]> wrote in General Discussion of SQLite
Database :
>Is there any free SqLite3 *Report Generator For MS-Windows.* I searched the
>web with Google but no result. All are commercial and/or with .NET, I want
>it use with VC++ 6.0. Eve
Christophe Leske wrote:
> John Stanton schrieb:
>
>>The sqlite3.exe program is set up as a utility and maintenance tool, not
>>a production environment and is designed to that end. If you want
>>maximum performance it is not the way to go; instead embed the Sqlite
>>calls inside your applicati
It's been a while since I used FreeBSD, but I remember sometimes
needing to use gmake (vs. just plain make) to get ports up and going.
-T
On Mon, Oct 20, 2008 at 12:02 PM, Adrian <[EMAIL PROTECTED]> wrote:
> Hello,
> I'm having trouble installing the SQLite3 port on FreeBSD, and I wanted t
I presume I'm not allowed to do this:
// apply updates on first db - start Transaction
ret = sqlite3_exec(
first_db,
"BEGIN; UPDATE " FIRST_DB_TABLE
" SET " FIRST_DB_COLUMN "=1 "
" WHERE " FIRST_DB_COLUMN " NOT NULL;"
Greetings,
Okay, I understand that the designer of SQLite felt it was important that
fields with a default value of CURRENT_DATE should be initialized to the
current date in a DIFFERENT time zone. Setting aside for now that I've read
all the reasons for this and am very much against the decision,
-- get the Nth record from the top:
select *
from tblname
order by id asc
limit N-1,1
-- get the Nth record from the bottom:
select *
from tblname
order by id desc
limit N-1,1
Regards,
-Toby
>Hi all
>I create a table like this:
>sqlite3_exec(db, "CREATE TABLE TBLNAME (ID
>INTEGER PRIMARY KEY ,
Hi,
this is most likely not an SQLite problem, but either a problem of the
SQLite3 port, or a glitch in the port system itself. To get better
advice, I'd recommend to contact the port maintainer and the
freebsd-users mailing list.
regards,
Markus
Quoting Adrian <[EMAIL PROTECTED]>:
> Hell
Hello,
I'm having trouble installing the SQLite3 port on FreeBSD, and I wanted to
see if my issue is one that is generally known or if it is something
particular on my end. If I go into the ports/databases/sqlite3 directory
and try "make", I get the following error:
"/usr/ports/Mk/bsd.port.mk", li
You could write your own sqlite3.exe, with an enhanced interface that
would allow loading queries with ? parameters, binding, eventual
destruction of said parameters. Spawn it in the background then use
your favorite IPC method to talk to it (another driver program
perhaps). Depends how crazy you
Hi all，
I create a table like this:
sqlite3_exec(db, "CREATE TABLE TBLNAME (ID INTEGER PRIMARY KEY
, NAME TEXT)", 0, 0,&zErrMsg);
Then insert some records, the follow is the contents of this table.
-
ID
On Oct 20, 2008, at 5:38 PM, jm cuaz wrote:
> Hello,
>
> We try to port an application specialised in financial calculus
> written
> in VBA + MS Access toward Tcl + Sqlite.
>
> In this application, 90% of the calculus is directly processed at the
> SQL level via INSERT/UPDATE statements execute
"yokk y" <[EMAIL PROTECTED]> wrote in
message
news:[EMAIL PROTECTED]
>I want to get the total rows of a table, here are my methods:
>
> Is there some more efficient methods or API interface with
> Sqlite?Because my program invoke this interface very frequency.
If it's really that important
Hello,
We try to port an application specialised in financial calculus written
in VBA + MS Access toward Tcl + Sqlite.
In this application, 90% of the calculus is directly processed at the
SQL level via INSERT/UPDATE statements executed against the db, and
subsets are calculated with INNER JOI
Hi,
when I use inserts through prepared statements on windows with ODBC
all text field values are messed up. Everything else, ie. numbers,
timestamps are fine.
When I'm using inserts without prepared statements, also via ODBC, the
strings are fine, save for Umlauts.
Is anybody else here experien
circ ular <[EMAIL PROTECTED]> writes:
>
> I have googled a lot but haven't found any really good tutorials on
> sqlite and/or relational databases in general.
> ___
> sqlite-users mailing list
> [EMAIL PROTECTED]
> http://sqlite.org:8080/cgi-bin/mailman
John Stanton schrieb:
> The sqlite3.exe program is set up as a utility and maintenance tool, not
> a production environment and is designed to that end. If you want
> maximum performance it is not the way to go; instead embed the Sqlite
> calls inside your application and optimize access. If y
28 matches
Mail list logo
