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
