Re: [sqlite] Suggest some Tools for Sqlite

2011-08-20 Thread Paul Linehan
2011/8/18 Madhankumar Rajaram : > I hope there should be some good Free or Licence Tools for using Sqlite. > For ex : Toad for Oracle. Hmmm Toad for SQLite - there's a thought. ;) > so, Kindly suggest the best Free / Licence Tool for using Sqlite > Thanks Try the

Re: [sqlite] SQL query help

2011-08-20 Thread Paul Sanderson
Hmm thanks Roger Table could have a few million rows, i'll have a play and see what the run time is. The relevant column is indexed On 20 August 2011 17:14, Roger Andersson wrote: >  On 08/20/11 05:42 PM, Paul Sanderson wrote: >> Hi all >> >> I am trying to create a query that

Re: [sqlite] SQL query help

2011-08-20 Thread Roger Andersson
On 08/20/11 05:42 PM, Paul Sanderson wrote: > Hi all > > I am trying to create a query that works to craete a subset of a table > based on duplicate items > > Examples work best so consider the contrived table with the following rows > 10 socata > 7 socata > 13 cessna > 2 piper > 7 piper > 55

[sqlite] SQL query help

2011-08-20 Thread Paul Sanderson
Hi all I am trying to create a query that works to craete a subset of a table based on duplicate items Examples work best so consider the contrived table with the following rows 10 socata 7 socata 13 cessna 2 piper 7 piper 55 piper 1 diamond I want to see the subset that is 10 socata 7 socata 2

Re: [sqlite] SQLite + unicode

2011-08-20 Thread Jean-Christophe Deschamps
>I try this function. Do you have Visual Studio. i show you my example. > >NOCaut wrote: > > > > > > char * unicode_to_1251(wchar_t *unicode_string) Why are you converting Unicode to 1251? This is a lossy conversion in the general case. Work with Unicode strings end-to-end, using the UTF

Re: [sqlite] SQLite + unicode

2011-08-20 Thread NOCaut
this is my example spellings on the VS2008 http://www.4shared.com/file/RDzSVPZq/SQLite_example.html -- View this message in context: http://old.nabble.com/SQLite-%2B-unicode-tp32296232p32301433.html Sent from the SQLite mailing list archive at Nabble.com.

Re: [sqlite] SQLite + unicode

2011-08-20 Thread NOCaut
I try this function. Do you have Visual Studio. i show you my example. NOCaut wrote: > > > char * unicode_to_1251(wchar_t *unicode_string) > { > int err; > char * res; > int res_len = WideCharToMultiByte( > 1251, // Code page >

Re: [sqlite] SQLite + unicode

2011-08-20 Thread Kees Nuyt
On Sat, 20 Aug 2011 01:45:42 -0700 (PDT), NOCaut wrote: > For "" and '' i know thanks, and why you write ? > i want write arabic symbul Apparently your utf-8 Arabic characters were dropped and replaced by ?, probably by my mail reader. My apologies.

Re: [sqlite] SQLite + unicode

2011-08-20 Thread NOCaut
For "" and '' i know thanks, and why you write ? i want write arabic symbul مثالمثالمثالمثال -- View this message in context: http://old.nabble.com/SQLite-%2B-unicode-tp32296232p32300446.html Sent from the SQLite mailing list archive at Nabble.com.

Re: [sqlite] type of a value bound by sqlite3_bind_blob ()?

2011-08-20 Thread Ivan Shmakov
> Ivan Shmakov writes: > Roger Binns writes: […] >> Consequently if you had a trigger pulling a stunt like this, your >> code could try to insert a blob and silently (wrongly) end up with a >> string. SQLite won't even complain if the blob isn't a valid text >> encoding producing an