Re: [sqlite] Index Problem

2009-12-10 Thread Harish Dixit
Hi, One more information: I am using COLLATE NoCase. On Thu, Dec 10, 2009 at 4:19 PM, Harish Dixit <harishdix...@gmail.com>wrote: > Hi Friends, > > I ran into a big problem of creating indexes taking a long time. When i > create index on multiple colomns then its taking

[sqlite] Index Problem

2009-12-10 Thread Harish Dixit
Hi Friends, I ran into a big problem of creating indexes taking a long time. When i create index on multiple colomns then its taking a long time on few machines. Those are windows Vista machines. I am using following command: CREATE INDEX IF NOT EXISTS New_Index (name,title) I tried with empty

Re: [sqlite] String is changing after inserting into database

2008-07-03 Thread Harish Dixit
Hello friends, I came across a new problem. My database is currupted. When i ran the integrity check then i found the following results: *Is there any tool available which can repair it?* *Result:* RecNointegrity_check 1*** in database main *** On tree page 581 cell 1: invalid page

[sqlite] SQLite database problem

2008-07-03 Thread Harish Dixit
Hello friends, I did the integrity check on the given db3 file. Here are the results: Is there any tool to repair the database RecNointegrity_check 1*** in database main *** On tree page 581 cell 1: invalid page number 1711301632 On tree page 581 cell 2: invalid page number 956314624 On

Re: [sqlite] String is changing after inserting into database

2008-04-18 Thread Harish Dixit
Yes I am using all these 16 bit method calls. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] String is changing after inserting into database

2008-04-18 Thread Harish Dixit
bs.net > http://www.sqlabs.net/blog/ > http://www.sqlabs.net/realsqlserver/ > > > > On Apr 18, 2008, at 8:37 AM, Harish Dixit wrote: > > > Hello, > > > > I am inserting some unicode string into the SQLite database. After > > inserting, at the time of retriev

[sqlite] String is changing after inserting into database

2008-04-18 Thread Harish Dixit
Hello, I am inserting some unicode string into the SQLite database. After inserting, at the time of retrieving value has been modified. For example: I am inserting "즒铭ꓽ菷\큭셙냼誜\꾁霤꿩뱪낌.wma" when i am retrieving it the value is : "馒铭ꓽ菷\큭셙냼誜\꾁霤꿩뱪낌.wma" It seems that the problem is related to