I have code in C++. Right now, I got this issue on Mac. >>you still have faulty hardware or software
faulty software means? (OS or sqlite version) On Sun, Dec 9, 2012 at 3:37 PM, Simon Slavin <slav...@bigfraud.org> wrote: > > On 9 Dec 2012, at 7:34am, dd <durga.d...@gmail.com> wrote: > > > I have 10 databases. One database got disk io error, later it's used by > > application without proper handling, so it's corrupted. > > > > After some days, one more database also corrupted without io error. > Sqlite > > returned error code 11. It's fully corrupted. Are these corruptions > depend > > on other database integrity? > > Corruption may spread from one database to another if you have a corrupt > database open at the same time as an uncorrupt database. It is rare but it > can happen. If you are no longer opening corrupt database files and are > still getting more corruption you still have faulty hardware or software. > > > I am using this database for "schengen countries" customers. Can sqlite > > handle these characters(special)? > > SQLite handles text in UTF-8 or UTF-16 format. If you are storing data in > a database relying on other Windows codepages then you will get strange > results. If you are allowing non-Roman characters and rely on your user's > codepage when handling text, use a routine like 'WideCharToMultiByte': > > <http://msdn.microsoft.com/en-us/library/dd374130(v=vs.85).aspx> > > to convert the data to UTF-8 or UTF-16 before storing it in the SQLite > database. Actually it's easier to convert your text to Unicode immediately > you receive it from your user. You do not have to use the above routine, I > provide it just as an example. > > I can't help more without knowing what OS and programming language you're > using but maybe someone else can. > > Simon. > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
