On 2 Jan 2012, at 7:35am, Baruch Burstein wrote:
> On Sun, Jan 1, 2012 at 8:12 PM, Simon Slavin wrote:
>
>>> First, don't worry about inefficient. What you need to worry about is
>>> not-efficient-enough. For instance, your app taking 1/10th of a second
>>> slower is not a problem, but if you
On Sun, Jan 1, 2012 at 8:12 PM, Simon Slavin wrote:
>
> On 1 Jan 2012, at 5:27pm, Baruch Burstein wrote:
>
> > I need a file format to hold a bunch of resources for my program. I
> thought
> > of using SQLite. However, I am debating two formats. The
> > more convenient one for me would put every
On 2 Jan 2012, at 5:25am, Durga D wrote:
> "create table if not exists durtree (id integer primary key autoincrement,
> c1 varchar[260], c2 varchar[260], c3 varchar[260], c4 varchar[260], c5
> varchar[260], c6 varchar[260], c7 varchar[260], c8 varchar[260], c9
> varchar[260], c10 varchar[260], c
Kai Peters wrote:
> Hi,
>
> how can I insert a control character like carriage return?
>
> Something like:
>
> update fielddefs set choices = 'Male' || '\r' || 'Female' where id = 2
update ... 'Male' || X'0D' || 'Female' ...
___
sqlite-users mailing
Dear Aris,
Wish you a happy new year.
I agree.
I think, it may not support for search with wild chars. like vil*
Can I get wild char search in leaf node or parent node with XML?
Thanks,
Durga.
On Fri, Dec 30, 2011 at 8:05 PM, Aris Setyawan wrote:
> Hi Durga,
>
> Another al
Thanks for your responses.
Wish you a Happy new year.
I tested with below query to create a table:
"create table if not exists durtree (id integer primary key autoincrement,
c1 varchar[260], c2 varchar[260], c3 varchar[260], c4 varchar[260], c5
varchar[260], c6 varchar[260], c7 varchar[260], c8
On 1 Jan 2012, at 7:40pm, Zbigniew wrote:
> Reading the contents of the blog
> http://milky.manishsinha.net/2009/03/30/sqlite-with-c/ tried to follow
> the tips to access SQLite database from C, but there's a problem:
> actually database should keep UTF-8 encoded data. No problem, when
> one's us
Reading the contents of the blog
http://milky.manishsinha.net/2009/03/30/sqlite-with-c/ tried to follow
the tips to access SQLite database from C, but there's a problem:
actually database should keep UTF-8 encoded data. No problem, when
one's using LATIN1 - but I tried LATIN2 strings, and they were
On 1 Jan 2012, at 5:27pm, Baruch Burstein wrote:
> I need a file format to hold a bunch of resources for my program. I thought
> of using SQLite. However, I am debating two formats. The
> more convenient one for me would put every few resources in
> a separate table. However, this would result in
2012/1/1 Baruch Burstein :
> I need a file format to hold a bunch of resources for my program. I thought
> of using SQLite. However, I am debating two formats. The
> more convenient one for me would put every few resources in
> a separate table. However, this would result in small tables. Am I righ
I need a file format to hold a bunch of resources for my program. I thought
of using SQLite. However, I am debating two formats. The
more convenient one for me would put every few resources in
a separate table. However, this would result in small tables. Am I right
that this is very inefficient in
On Sat, 31 Dec 2011 13:16:58 -0800, Kai Peters
wrote:
>
>Hi,
>
>how can I insert a control character like carriage return?
>
>Something like:
>
>update fielddefs
> set choices = 'Male' || '\r' || 'Female' where id = 2
Line endings can be included in text literals:
UPDATE fielddefs
SET cho
12 matches
Mail list logo