Hi,
thank you very much,
I enjoy so much sqlite with ICU,
I even installed the latest version of readline to enjoy characters like öäü
and with the ICU collation the sort order is right with those characters.
sqlite is really splendid!
Thank you so much for having made this software.
Best regar
Walter wrote:
> > I have the following tables
> >
> > CREATE TABLE data(
> > id INTEGER PRIMARY KEY NOT NULL,
> > name TEXT DEFAULT '',
> > titleTEXT DEFAULT '',
> >
> > )
> >
> >
> > CREATE TABLE pivot(
> > id INTEGER PRIMARY KEY NOT NULL,
> > link1I
>Something like (one line, wrapped by email):
>
>echo "INSERT INTO t1 (id,pic) VALUES (1,X'$(od -A n -t x1
>picture.gif | tr -d '\r\n\t\ ')')" | sqlite3 mydb
>
>(The od utility may be smarter than that, optimization left
>to the OP)
Looks good, you know better than I do. Just checked: od and tr
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Sylvain Pointeau wrote:
> just one last thing:
> -lpthread -lm -L/usr/local/lib -licui18n -licuuc -licudata -lpthread -lm
>
>
> could it be annoying for sqlite to be linked against pthread?
Unless you compiled SQLite with SQLITE_THREADSAFE=0 then
On Thu, 10 Dec 2009 04:57:58 +0100, Jean-Christophe
Deschamps wrote:
> is to
>use a command-line tool or combination thereof that will open your
>binary file, read each byte in turn and output its hex value in plain
>ASCII characters, until end of file.
Something like (one line, wrapped by e
super thank you! :-D
just one last thing:
-lpthread -lm -L/usr/local/lib -licui18n -licuuc -licudata -lpthread -lm
could it be annoying for sqlite to be linked against pthread?
Many thanks,
Sylvain
On Thu, Dec 10, 2009 at 7:45 PM, Roger Binns wrote:
> -BEGIN PGP SIGNED MESSAGE-
>
On Thu, Dec 10, 2009 at 10:18 AM, Daniel Mierswa wrote:
> My concolusion is that the TB folks shouldn't assume that the system
> sqlite library was built with debugging symbols or provide a mechanism
> to opt out said function call with an easy switch/compiler flag.
>
Well, there is your problem.
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Sylvain Pointeau wrote:
> seems I found:
>
> ./configure CFLAGS="-DSQLITE_ENABLE_ICU" LDFLAGS="-L/usr/local/lib"
> LIBS="-licudata -licui18n -licuio -licule -liculx -licutu -licuuc"
>
> is there any way to not list all the icu libs?
Use icu-config.
On Dec 10, 2009, at 1:13 PM, Alexey Pechnikov wrote:
> Hello!
>
> In new relise doesn't some queries. The simplest non-working query
> is like to:
>
> sqlite> select 1 from file_text where rowid=1 and file_text match
> 'document';
> Error: SQL logic error or missing database
>
> sqlite> selec
On 10.12.2009 07:44, Roger Binns wrote:
> sqlite3.h is not generated from a .in template. Are you volunteering to do
> that and become the maintainer of it?
Nah I was merely wondering how/if it could be achieved at all.
> Secondly your solution would only work for autotools which not everyone use
seems I found:
./configure CFLAGS="-DSQLITE_ENABLE_ICU" LDFLAGS="-L/usr/local/lib"
LIBS="-licudata -licui18n -licuio -licule -liculx -licutu -licuuc"
is there any way to not list all the icu libs?
Best regards,
Sylvain
On Thu, Dec 10, 2009 at 4:09 PM, Sylvain Pointeau <
sylvain.point...@gmail.c
./configure CFLAGS="-DSQLITE_ENABLE_ICU
but after I have a linker problem:
/bin/sh ./libtool --tag=CC --mode=link gcc -DSQLITE_THREADSAFE=1
-DSQLITE_ENABLE_ICU -I/usr/local/include -L/usr/local/lib -o
libsqlite3.la-rpath /usr/local/lib -no-undefined -version-info 8:6:8
sqlite3.lo
gcc -dynamicli
... I don't have this line in my Makefile.in ...
Are you sure there is not an option to put in the "configure" command?
Best regards,
Sylvain
On Thu, Dec 10, 2009 at 3:44 PM, Alexey Pechnikov wrote:
> Hello!
>
> On Thursday 10 December 2009 17:40:24 Sylvain Pointeau wrote:
> > Thank you very muc
Hello!
On Thursday 10 December 2009 17:40:24 Sylvain Pointeau wrote:
> Thank you very much.
> How should I do exactly with configure to enable this define ?
You can simple replace the string
TCC += -D_HAVE_SQLITE_CONFIG_H
to
TCC += -D_HAVE_SQLITE_CONFIG_H -DSQLITE_ENABLE_ICU
in the Makefine.in
B
Hi,
Thank you very much.
How should I do exactly with configure to enable this define ?
Cheers,
Sylvain
On Thu, Dec 10, 2009 at 11:31 AM, Simon Davies <
simon.james.dav...@googlemail.com> wrote:
> 2009/12/10 Sylvain Pointeau :
> > Hi,
> >
> > I would like to use ICU with sqlite, I am on mac os
Simon,
Thanks a lot. This is just what I needed.
Greg
From: Simon Slavin
To: General Discussion of SQLite Database
Sent: Wed, December 9, 2009 4:34:09 PM
Subject: Re: [sqlite] iPhone App close database
On 9 Dec 2009, at 11:13pm, Greg Walters wrote:
> I am l
You should keep your id and the imdbid in separate columns, because you
can then insert a title even if IMDB does not have it yet.
id INTEGER PRIMARY KEY
imdbid integer// you should allow this column to be null
title not null,
et cetera
Regards
Tim Romano
Yuzem wrote:
> CREATE TABLE movi
2009/12/10 Yuzem :
>
> CREATE TABLE movies(id integer,title text,unique(id))
>
> Generally I have an unique id from imdb but some times the movie isn't
> available.
> I understand that there is a column called rowid that is the primary key.
> I would like to insert the rowid on the id column when I
CREATE TABLE movies(id integer,title text,unique(id))
Generally I have an unique id from imdb but some times the movie isn't
available.
I understand that there is a column called rowid that is the primary key.
I would like to insert the rowid on the id column when I don't have an id
for the movie
Hi,
One more information:
I am using COLLATE NoCase.
On Thu, Dec 10, 2009 at 4:19 PM, Harish Dixit wrote:
> Hi Friends,
>
> I ran into a big problem of creating indexes taking a long time. When i
> create index on multiple colomns then its taking a long time on few
> machines. Those are windows
Hi Friends,
I ran into a big problem of creating indexes taking a long time. When i
create index on multiple colomns then its taking a long time on few
machines. Those are windows Vista machines. I am using following command:
CREATE INDEX IF NOT EXISTS New_Index (name,title)
I tried with empty d
2009/12/10 Sylvain Pointeau :
> Hi,
>
> I would like to use ICU with sqlite, I am on mac os x 10.6.2
> How should I do? I installed ICU but sqlite3 seems to not check ICU when
> compiling.
> I would like to use ICU via the sqlite shell.
>
> Please could someone explain me how to use ICU with sqlite
Hi,
I would like to use ICU with sqlite, I am on mac os x 10.6.2
How should I do? I installed ICU but sqlite3 seems to not check ICU when
compiling.
I would like to use ICU via the sqlite shell.
Please could someone explain me how to use ICU with sqlite3 ?
Cheers,
Sylvain
___
On Mon, Dec 7, 2009 at 10:21 PM, wrote:
>
> SQLite bug report
>
> Summary:
> --
>
> error message:
>
> Error: near line 2: database or disk is full
>
> It happens with plenty of disk space available and with 'unlimited' database
> size.
> It does not happen on all systems. It d
>-Message d'origine-
>De : sqlite-users-boun...@sqlite.org
>[mailto:sqlite-users-boun...@sqlite.org] De la part de J. King
>Envoyé : mardi, 8. décembre 2009 18:24
>À : General Discussion of SQLite Database
>Objet : Re: [sqlite] Implementing Regular Expression Support...?
>
>On Tue, 08 D
25 matches
Mail list logo