Re: [sqlite] How to store as integer

2017-12-06 15:46 GMT+01:00 Peter Da Silva : > I’d recommend expr {double($temp)} so the bytecode compiler can optimize > the expression. > > On 12/6/17, 8:40 AM, "sqlite-users on behalf of Cecil Westerhof" < > sqlite-users-boun...@mailinglists.sqlite.org on behalf

Re: [sqlite] How to store as integer

I’d recommend expr {double($temp)} so the bytecode compiler can optimize the expression. On 12/6/17, 8:40 AM, "sqlite-users on behalf of Cecil Westerhof" wrote: return [expr double(${temp})]

Re: [sqlite] How to store as integer

2017-12-06 14:58 GMT+01:00 Simon Slavin : > > > On 6 Dec 2017, at 1:19pm, Cecil Westerhof wrote: > > >message NOT NULL > > Given thqt you want the "message" stored as REAL, you should be defining > this column as REAL. This is

Re: [sqlite] How to store as integer

On 6 Dec 2017, at 1:19pm, Cecil Westerhof wrote: >message NOT NULL Given thqt you want the "message" stored as REAL, you should be defining this column as REAL. This is necessary, though not sufficient. Simon.

Re: [sqlite] How to store as integer

2017-12-06 13:34 GMT+01:00 Darko Volaric : > How it's stored depends on how the messages table is defined (which type > the message column has been given), which you haven't shown, and whether > storeMessage quotes the message argument when forming the string. My advice > is to

Re: [sqlite] How to store as integer

How it's stored depends on how the messages table is defined (which type the message column has been given), which you haven't shown, and whether storeMessage quotes the message argument when forming the string. My advice is to remove any column type and make sure numbers are not quoted when they

Re: [sqlite] how to store latin strings with no casae

Thank you. On Fri, Oct 24, 2014 at 11:24 PM, Constantine Yannakopoulos < alfasud...@gmail.com> wrote: > On Fri, Oct 24, 2014 at 9:40 AM, dd wrote: > > > > > >>The SQLite source code includes an "ICU" extension that does these > > overloads. > > > > Will it solve for all

Re: [sqlite] how to store latin strings with no casae

On Fri, Oct 24, 2014 at 9:40 AM, dd wrote: > > >>The SQLite source code includes an "ICU" extension that does these > overloads. > > Will it solve for all charsets if ICU enabled? > > ​Probably but I cannot tell for sure because I haven't used it.​ When my company started

Re: [sqlite] how to store latin strings with no casae

Thanks for your response. https://www.sqlite.org/faq.html#q18 >>The SQLite source code includes an "ICU" extension that does these overloads. Will it solve for all charsets if ICU enabled? On Thu, Oct 23, 2014 at 6:28 PM, Constantine Yannakopoulos < alfasud...@gmail.com> wrote: > On Thu, Oct

Re: [sqlite] how to store latin strings with no casae

On Thu, Oct 23, 2014 at 2:47 PM, dd wrote: > Hi, > > database schema defined with collate nocase. It supports only for ascii > (upper and lower). If I want to support db for other characters with > nocase, what steps I need to consider during schema design. > > for ex: >

Re: [sqlite] How to store and retrieve list of images from sqlite in android

On Tue, Sep 20, 2011 at 1:56 PM, Simon Slavin wrote: > Sorry, Mayuri. I don't program for Android. I don't know what programming > is needed or have an emulator. You are still writing to a mailing list > about SQLite. I think you need a mailing list about Android. >

Re: [sqlite] How to store and retrieve list of images from sqlite in android

On 20 Sep 2011, at 6:17am, Mayuri wrote: > Here i attached my application. Sorry, Mayuri. I don't program for Android. I don't know what programming is needed or have an emulator. You are still writing to a mailing list about SQLite. I think you need a mailing list about Android. Simon.

Re: [sqlite] How to store and retrieve list of images from sqlite in android

Here I attached one more application this application is showing different bitmap addresses but its not showing images in emulator.I wrote code for retrieving images from sqlite but its showing error.this code is showing text message. I want displaying images in emulator. if u know please send me

Re: [sqlite] How to store and retrieve list of images from sqlite in android

Hi Simon, Here i attached my application.check once. http://old.nabble.com/file/p32500286/databaseex.rar databaseex.rar This application retrieving only one image.now i want retrieving list of images like this. -- View this message in context:

Re: [sqlite] How to store and retrieve list of images from sqlite in android

On 19 Sep 2011, at 12:46pm, Mayuri wrote: > I want to make application that fetch Images and profile > of the person from the DataBaseand not from the XML...I know thats a > difficult task You have two obvious options: Store your image in an image file, and store the path to that file

Re: [sqlite] How to store and retrieve list of images from sqlite in android

See this image link I want to make application that fetch Images and profile of the person from the DataBaseand not from the XML...I know thats a difficult task

Re: [sqlite] How to store and retrieve list of images from sqlite in android

We don't know how to help you. There are many ways to store images in a SQLite database. You write software to put them in and more software to retrieve them. Whatever problem you have doesn't seem to be related to SQLite. And you say > I am trying to store list of images in sqlite it's

Re: [sqlite] How to store and retrieve list of images from sqlite in android

WOW even I am looking for it ...i you get help just inform me to plz Mayuri wrote: > > Hi All, > I did one application store and retrieve only one image from sqlite,now > I am trying to store list of images in sqlite it's done but I unable to > retrieve those images on emulator. >

Re: [sqlite] How to store and retrieve list of images from sqlite in android

* I wrote the code in java file for displaying images.But those images are not displaying in emulator. If you possible give me a sample application to retrieve list of images from sqlite. -- View this message in context:

Re: [sqlite] How to store and retrieve list of images from sqlite in android

Thanks for your replay. I wrote the code in java file for displaying images.But those images are not displaying in emulator. If you possible give me a sample application to retrieve list of images from sqlite. -- View this message in context:

Re: [sqlite] How to store and retrieve list of images from sqlite in android

On 15 Sep 2011, at 1:35pm, Mayuri wrote: > As a BLOB. > > we are able to see these images in SQLite Expert. But those images are not > visible in emulator. SQLite Expert is doing its own magic in order to interpret the contents of the BLOB field as an image. This is not something built into

Re: [sqlite] How to store and retrieve list of images from sqlite in android

As a BLOB. we are able to see these images in SQLite Expert. But those images are not visible in emulator. -- View this message in context: http://old.nabble.com/How-to-store-and-retrieve-list-of-images-from-sqlite-in-android-tp32469610p32471232.html Sent from the SQLite mailing list

Re: [sqlite] How to store and retrieve list of images from sqlite in android

On 15 Sep 2011, at 8:38am, Mayuri wrote: > I did one application store and retrieve only one image from sqlite,now I > am trying to store list of images in sqlite it's done but I unable to > retrieve those images on emulator. How did you store your image ? As a BLOB ? Or as a pointer to a

RE: [sqlite] How to store 128 bit values

m: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 11 July 2007 20:17 To: sqlite-users@sqlite.org Subject: Re: [sqlite] How to store 128 bit values "RB Smissaert" <[EMAIL PROTECTED]> wrote: > > Looking up a record by INTEGER PRIMARY KEY is always twice as > > fast as lo

Re: [sqlite] How to store 128 bit values

"RB Smissaert" <[EMAIL PROTECTED]> wrote: > > Looking up a record by INTEGER PRIMARY KEY is always twice as > > fast as looking up the same record by any other key > > Didn't realize that, but I have a question in connection with this. > It seems if you do inserts on a table it is faster if you

RE: [sqlite] How to store 128 bit values

TECTED] [mailto:[EMAIL PROTECTED] Sent: 11 July 2007 19:33 To: sqlite-users@sqlite.org Subject: Re: [sqlite] How to store 128 bit values "Steve Krulewitz" <[EMAIL PROTECTED]> wrote: > Hey all -- > > In the application I am working on (Songbird), we have a simple

Re: [sqlite] How to store 128 bit values

"Steve Krulewitz" <[EMAIL PROTECTED]> wrote: > Hey all -- > > In the application I am working on (Songbird), we have a simple two > table schema representing the tracks in your music collection and the > properties on those tracks. The keys used are all UUIDs (128 bit > number) which we are

Re: [sqlite] How to store 128 bit values

On 7/11/07, Steve Krulewitz <[EMAIL PROTECTED]> wrote: In the application I am working on (Songbird), we have a simple two table schema representing the tracks in your music collection and the properties on those tracks. The keys used are all UUIDs (128 bit number) which we are currently

Re: [sqlite] How to store 128 bit values

On 7/11/07, Steve Krulewitz <[EMAIL PROTECTED]> wrote: I was wondering if there is much to be gained by storing these 128 bit values in binary rather than as strings. We estimate roughly 20 properties per track, so in a moderate sized database you'd have 10k rows in the tracks table and 200k

Re: [sqlite] how to store date/time in sqlite?

On Sep 13, 2005, at 11:07 AM, Mark Wyszomierski wrote: Moving from a mysql database to sqlite. I had some date/time fields in my mysql database. I would just populate them using the now() function. How could I achieve the same in my new sqlite database? This page might be helpful:

Re: [sqlite] how to store date/time in sqlite?

Ah excellent, thanks Jay, Mark On 9/13/05, Jay Sprenkle <[EMAIL PROTECTED]> wrote: > > See the wiki section of the documentation on the web site. There's a page > devoted to this. > > On 9/13/05, Mark Wyszomierski < [EMAIL PROTECTED]> wrote: > > > > Hi all, > > Moving from a mysql

Re: [sqlite] how to store date/time in sqlite?

See the wiki section of the documentation on the web site. There's a page devoted to this. On 9/13/05, Mark Wyszomierski <[EMAIL PROTECTED]> wrote: > > Hi all, > Moving from a mysql database to sqlite. I had some date/time fields in my > mysql database. I would just populate them using the

Re: [sqlite] How to store ' ?

Gosh, sorry, just re-read the faq: INSERT INTO xyz VALUES('5 O''clock'); - Original Message - From: "Edwin Knoppert" <[EMAIL PROTECTED]> To: Sent: Tuesday, July 19, 2005 1:49 PM Subject: [sqlite] How to store ' ? If i read correct BLOB data can now handle