Re: [sqlite] UTF-8 and UTF-16

Thank you for your help! This call: sqlite3_exec(handle,"PRAGMA encoding = \"UTF-16\"",NULL,NULL,); works. Samuel - Original Message From: Igor Tandetnik To: sqlite-users@sqlite.org Sent: Sun, January 31, 2010 6:12:27 PM Subject: Re: [sqlite] UTF-8 and UTF-16

Re: [sqlite] UTF-8 and UTF-16

On Sun, 31 Jan 2010 18:12:27 -0500, "Igor Tandetnik" wrote: >It's PRAGMA encoding = "UTF-16". The parameter needs to be quoted. This is indeed the syntax description. Peculiarly, anywhere else, string literals have to be single quoted. Is this something to iron out in v4 ?

Re: [sqlite] UTF-8 and UTF-16

a1rex wrote: > I am planning to store text in a database which has to accommodate a few > international languages. > In this case I have to use UTF-16LE encoding for my TEXT fields. Perhaps there are some external reasons, but there's nothing in SQLite that would force this. For example, UTF-8

[sqlite] UTF-8 and UTF-16

I am planning to store text in a database which has to accommodate a few international languages. In this case I have to use UTF-16LE encoding for my TEXT fields. I know that once an encoding has been set for a database, it cannot be changed. Do BLOBS are effected? I guess I cannot mix

[sqlite] system.data.sqlite & encryption

Hi all, I am using System.data.sqlite from my .NET project, but I am planning to access my db from C/C++ and C# / C++/CI The point is that I want an encryted database, and I plan to use the extension from http://www.hwaci.com/sw/sqlite/prosupport.html#crypto how to use / implement this exension

Re: [sqlite] negative numbers

On Sun, Jan 31, 2010 at 9:42 AM, Jay A. Kreibich wrote: > On Sun, Jan 31, 2010 at 09:11:21AM -0600, P Kishor scratched on the wall: >> On Sun, Jan 31, 2010 at 8:19 AM, james pruett wrote: >> > I am writing an open source program. >> > >> > I am having trouble

Re: [sqlite] negative numbers

On Sun, Jan 31, 2010 at 09:11:21AM -0600, P Kishor scratched on the wall: > On Sun, Jan 31, 2010 at 8:19 AM, james pruett wrote: > > I am writing an open source program. > > > > I am having trouble getting any results using this query. This returns > > none > > select *

Re: [sqlite] negative numbers

On Sun, Jan 31, 2010 at 8:19 AM, james pruett wrote: > I am writing an open source program. > > I am having trouble getting any results using this query. This returns > none > > select * from signs where lon>-121 and lon<-119; > > onCreate(SQLiteDatabase db) { >      

Re: [sqlite] negative numbers

On 31 Jan 2010, at 2:19pm, james pruett wrote: > I am having trouble getting any results using this query. This returns > none > > select * from signs where lon>-121 and lon<-119; > > onCreate(SQLiteDatabase db) { > db.execSQL("CREATE TABLE " + TABLE_NAME + " (" + _ID >+

Re: [sqlite] negative numbers

On Jan 31, 2010, at 9:19 AM, james pruett wrote: > I am writing an open source program. > > I am having trouble getting any results using this query. This > returns none > > select * from signs where lon>-121 and lon<-119; > > onCreate(SQLiteDatabase db) { > db.execSQL("CREATE TABLE "

[sqlite] negative numbers

I am writing an open source program. I am having trouble getting any results using this query. This returns none select * from signs where lon>-121 and lon<-119; onCreate(SQLiteDatabase db) { db.execSQL("CREATE TABLE " + TABLE_NAME + " (" + _ID + " INTEGER PRIMARY KEY

Re: [sqlite] parallelizing an update

Hello, it is not aesthetic, it groups all update in a single transaction that speed up the processing. Using multi thread or multi-process is not efficient, it is at the end a single process that can write to the database (a single file). Grouping all the update in a single transaction is the