Re: [sqlite] Re: Unicode Help

On Dec 5, 2006, at 8:42 AM, Igor Tandetnik wrote: Da Martian <[EMAIL PROTECTED]> wrote: So if I look at a name with umlaughts in the database via sqlite3.exe I get: Städt. Klinikum Neunkirchen gGmbH -- | an "a" with two dots on top "A with umlaut" is represented as two bytes in

Re: [sqlite] Re: Unicode Help

On 12/7/06, Da Martian <[EMAIL PROTECTED]> wrote: Yeah I am currently using VirtualTree from Mikes Delphi Gems. Its fully unicode enabled (I beleive). I use WideStrings through out the entire pipeline from xml I recieve into SQLite via the prepare16 back out through column_text16 into virtual

[sqlite] about call back of sqlite.

Hi sqlite, I want to using sqlite this way. Application A register callback to sqlite db. And application B will modify sqlite db. I want each time sqlite was modified by B, A is notified by callback. Is this possible in sqlite? A and B run in different process. Thanks!

Re: [sqlite] Unicode Help

On 12/7/06, Nuno Lucas <[EMAIL PROTECTED]> wrote: On 12/7/06, Da Martian <[EMAIL PROTECTED]> wrote: > Ok, that does answer one of my questions I think. If I passed something not > in UTF-8 to sqlite would it return it exactly the same way I passed it in? > From your statement of chaos below I

Re: [sqlite] Interbase to SQLite

Indeed, my friend. D is as fast as c, but as easy to code as jscript, c# and java. And it's compiled language. Stand alone without JRE or some special library. - Original Message - From: "RB Smissaert" <[EMAIL PROTECTED]> To: Sent: Thursday, December 07,

Re: [sqlite] Searching for data

Thanks, this one does work. - Original Message - From: "Dan Baker" <[EMAIL PROTECTED]> To: Sent: Thursday, December 07, 2006 6:24 PM Subject: Re: [sqlite] Searching for data I do this in the following way: SELECT * FROM tbl WHERE (cola LIKE '%hello%' OR

Re: [sqlite] Using ODBC with Microsoft Access

Thanks. Turned out to be a bad driver. Got the update and everything works as expected. - Original Message From: Nikki Locke <[EMAIL PROTECTED]> To: sqlite-users@sqlite.org Sent: Thursday, December 7, 2006 4:30:15 AM Subject: Re: [sqlite] Using ODBC with Microsoft Access Buzz Hill

Re: [sqlite] Unicode Help

On 12/7/06, Da Martian <[EMAIL PROTECTED]> wrote: Ok, that does answer one of my questions I think. If I passed something not in UTF-8 to sqlite would it return it exactly the same way I passed it in? From your statement of chaos below I assume it wont if that data somehow violates UTF-8. So I

Re: [sqlite] Searching for data

I do this in the following way: SELECT * FROM tbl WHERE (cola LIKE '%hello%' OR colb LIKE '%hello%' OR colc LIKE '%hello%') AND (cola LIKE '%juan%' OR colb LIKE '%juan%' OR colc LIKE '%juan%') AND (cola LIKE '%casa%' OR colb LIKE '%casa%' OR colc LIKE '%casa%') This will return all records that

RE: [sqlite] Searching for data

How about simply: WHERE cola LIKE '%hello%juan%casa%' OR colb LIKE '%hello%juan%casa%' Etc. RBS -Original Message- From: jose isaias cabrera [mailto:[EMAIL PROTECTED] Sent: 07 December 2006 22:55 To: sqlite-users@sqlite.org Subject: [sqlite] Searching for data Greetings. I have a

RE: [sqlite] Interbase to SQLite

Now do you reckon with D I could move data fast from Interbase to SQLite? RBS -Original Message- From: jose isaias cabrera [mailto:[EMAIL PROTECTED] Sent: 07 December 2006 22:31 To: sqlite-users@sqlite.org Subject: Re: [sqlite] Interbase to SQLite I would suggest the Programming

[sqlite] Searching for data

Greetings. I have a table with many columns. I would like to find records google-like on all the records. Say, for example the searching criteria is hello juan casa I would like to have any record that has all of those tokens in any of the columns. how would I do that with a select?

RE: [sqlite] Interbase to SQLite

Will have a look and thanks for the tip. RBS -Original Message- From: jose isaias cabrera [mailto:[EMAIL PROTECTED] Sent: 07 December 2006 22:31 To: sqlite-users@sqlite.org Subject: Re: [sqlite] Interbase to SQLite I would suggest the Programming Language D, my friend. :-)

Re: [sqlite] Interbase to SQLite

I would suggest the Programming Language D, my friend. :-) http://www.digitalmars.com/d/index.html The easiest and fastest language ever. Here is an example on how to use it with sqlite: http://www.dprogramming.com/enticeaddrbook.html you will have to go to the d forums and ask for help,

RE: [sqlite] Interbase to SQLite

OK, I think I get it now. There is no ready made dll, but I have to write one in C or C++. Trouble is I only know VB/VBA, so not too easy then. RBS -Original Message- From: Fred Williams [mailto:[EMAIL PROTECTED] Sent: 07 December 2006 17:43 To: sqlite-users@sqlite.org Subject: RE:

RE: [sqlite] Interbase to SQLite

> study up a bit (won't require much) on the "VCL" concept Will do that. RBS -Original Message- From: Fred Williams [mailto:[EMAIL PROTECTED] Sent: 07 December 2006 17:43 To: sqlite-users@sqlite.org Subject: RE: [sqlite] Interbase to SQLite well, now that you have one of the most

Re: [sqlite] Interbase to SQLite

>Were you saying there was a driver to connect to both Interbase dbExpress. The Delphi help has all the details. >and SQLite like an ODBC driver? DISQLite3 (http://www.yunqa.de/delphi/sqlite3/) gives direct access to SQLite, using the original SQLite API as you know it. Component wrappers or

RE: [sqlite] Interbase to SQLite

well, now that you have one of the most powerful development platforms in the known universe installed, study up a bit (won't require much) on the "VCL" concept. There are VCL's available for both Interbase and SQLite. Install them and sail on... Or, if you are an old "C" coder break out the

Re: [sqlite] Interbase to SQLite

Hi Dennis, I have installed the whole lot and it went very smoothly. Now though I am not sure what the next step is. Were you saying there was a driver to connect to both Interbase and SQLite like an ODBC driver? Or did you have something else in mind? RBS > RB Smissaert wrote: >> Unfortunately

Re: [sqlite] Re: creating own pragmas

Christian Smith schrieb: Dennis Cote uttered: Igor Tandetnik schrieb: G�nter Greschenz <[EMAIL PROTECTED]> wrote: i'm using "sqlite3_create_function()" to create own functions in my database. this is a really nice possibility to extend the database with powerful functions. but i did not

Re: [sqlite] Re: creating own pragmas

Dennis Cote uttered: Igor Tandetnik schrieb: G�nter Greschenz <[EMAIL PROTECTED]> wrote: i'm using "sqlite3_create_function()" to create own functions in my database. this is a really nice possibility to extend the database with powerful functions. but i did not find a way to create own

Re: [sqlite] a question about muticonnection

Mario Frasca uttered: Christian Smith wrote: You can use the rowid to track the row version, and a unique constraint on your key to track conflicts. When updating a record, read the row, including the rowid. Update any columns. When writing the row out, delete the existing rowid, then

Re: [sqlite] Interbase to SQLite

RB Smissaert wrote: Unfortunately it looks it needs installing the .NET framework and J#. I will keep it in mind, but for now that has put me off this route. Yes, since Turbo C++ is based on BDS 2006 which supports C# and Delphi.Net development. As a result it uses .Net to support the .Net

Re: [sqlite] a question about muticonnection

Christian Smith wrote: You can use the rowid to track the row version, and a unique constraint on your key to track conflicts. When updating a record, read the row, including the rowid. Update any columns. When writing the row out, delete the existing rowid, then insert the new updated row,

Re: [sqlite] a question about muticonnection

hongdong uttered: I just have a base question: assume user A and user B now both connection to a same database and both of them want to update a same record,but only one is allowed in this condition: A begin to browse the data in a client application,and load rowid into GUI and keep it in

Re: [sqlite] Unicode Help

Hi You seem really confused about the whole encoding issue. Yes definatly confused, I had always hope unicode would simplify the world, but my experiences have shown no such luck :-) Codepages haunted my past and encodings haunt my future :-) Ok, that does answer one of my questions I think.

Re: [sqlite] Re: Unicode Help

I am still having issues trying to get my charaters standardizsed. I spent > all of yesterday playing with ideas but it still in the dark. Whatever you were doing the first time was fine: I have been having that very thought! So if I look at a name with umlaughts in the database via

Re: [sqlite] Unicode Help

"Da Martian" <[EMAIL PROTECTED]> wrote: > When using the > NON16 version of prepare: > If I add text which is in UTF16 what happens? > > 16 Version: > If I add UTF16 text what happnes? > if I add UTF-8 Text what happens? > if I add ASCIII text what happnes? > You seem really confused about

Re: [sqlite] Re: Unicode Help

On 12/7/06, Da Martian <[EMAIL PROTECTED]> wrote: I am still having issues trying to get my charaters standardizsed. I spent all of yesterday playing with ideas but it still in the dark. Whatever you were doing the first time was fine: So if I look at a name with umlaughts in the database

Re: [sqlite] Re: Unicode Help

I think std function for convertions would be very helpful. I am still having issues trying to get my charaters standardizsed. I spent all of yesterday playing with ideas but it still in the dark. Part of my problem is I dont have a clue what my source data is encoded as. Does anyone know of a

Re: [sqlite] Using ODBC with Microsoft Access

Buzz Hill wrote: > I am trying to pull records from a Microsoft Access db using > ODBC. .. > The problem I am having is with > dates. Something as simple as: > > SELECT * FROM CostingHeader > where DeliveryDate = '2/6/2004' Access has its own unique syntax for dates (surrounded with # and