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

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

2008-04-21 Thread Scott Hess
My experience is that this kind of problem tends towards a he-said, she-said type of thing, and what happens in the end is that everyone is correct from their perspective, but there was some little bit of non-obvious thing that made one party's understanding of the encoding slightly different from

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 Doug
t; Behalf Of Harish Dixit > Sent: Friday, April 18, 2008 1:37 AM > To: sqlite-users@sqlite.org > Subject: [sqlite] String is changing after inserting into database > > Hello, > > I am inserting some unicode string into the SQLite database. After > inserting, at the time of r

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

2008-04-18 Thread Harish Dixit
Yes. It is UTF-16 encoded On Fri, Apr 18, 2008 at 12:21 PM, Marco Bambini <[EMAIL PROTECTED]> wrote: > Is your database UTF-16 encoded? > > More information at: http://www.sqlite.org/pragma.html > PRAGMA encoding section. > > --- > Marco Bambini > http://www.sqlabs.net >

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

2008-04-18 Thread Roger Binns
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Harish Dixit wrote: > It seems that the problem is related to the some symbols having ASCII value > between these ranges: That would be unicode code points (ASCII is zero through 127) :-) > 1.56320 - 57343 > 2.55296 - 56319 You will

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

2008-04-18 Thread Marco Bambini
Is your database UTF-16 encoded? More information at: http://www.sqlite.org/pragma.html PRAGMA encoding section. --- Marco Bambini http://www.sqlabs.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

[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