Re: [sqlite] [Windows] 3.13.0 recreate db from .dump file corrupts records with extended characters

2016-07-13 Thread Igor Korot
sqlite> .open test.restorednew.db > sqlite> SELECT path,hex(path) FROM "test-directories" WHERE id=68; > Jap�n (2002)|4A6170C3B36E20283230303229 > > > Regards > > Simon > > > -Original Message- > From: sqlite-users-boun...@mailinglists.sqlite.org

Re: [sqlite] [Windows] 3.13.0 recreate db from .dump file corrupts records with extended characters

2016-07-13 Thread S.Ajina
-boun...@mailinglists.sqlite.org [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of Keith Medcalf Sent: 13 July 2016 22:34 To: SQLite mailing list <sqlite-users@mailinglists.sqlite.org> Subject: Re: [sqlite] [Windows] 3.13.0 recreate db from .dump file corrupts records with extended characters

Re: [sqlite] [Windows] 3.13.0 recreate db from .dump file corrupts records with extended characters

2016-07-13 Thread Keith Medcalf
inal.db > sqlite3_v3.13.0 -init newdump2.sql test.restorednew2.db > > > Simon > > -Original Message----- > From: sqlite-users-boun...@mailinglists.sqlite.org [mailto:sqlite-users- > boun...@mailinglists.sqlite.org] On Behalf Of Clemens Ladisch > Sent: 13 July 2016

Re: [sqlite] [Windows] 3.13.0 recreate db from .dump file corrupts records with extended characters

2016-07-13 Thread S.Ajina
sqlite-users@mailinglists.sqlite.org Subject: Re: [sqlite] [Windows] 3.13.0 recreate db from .dump file corrupts records with extended characters S.Ajina wrote: > Can confirm that sqlite3.exe version 3.8.6 works ok restoring database > from a .dump dump.sql file using these commands > > ech

Re: [sqlite] [Windows] 3.13.0 recreate db from .dump file corrupts records with extended characters

2016-07-13 Thread Richard Hipp
On 7/13/16, S.Ajina wrote: >> To fix this, use the same mechanism for both output and input: >> >> sqlite3 old.db .dump > dump.sql >> sqlite3 new.db < dump.sql > > Yes this has worked. We use the method of dumping and recreating to overcome > some database corruptions -

Re: [sqlite] [Windows] 3.13.0 recreate db from .dump file corrupts records with extended characters

2016-07-13 Thread S.Ajina
2.sql && echo .dump) | sqlite3_v3.13.0 test.original.db sqlite3_v3.13.0 -init newdump2.sql test.restorednew2.db Simon -Original Message- From: sqlite-users-boun...@mailinglists.sqlite.org [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of Clemens Ladisch Sent: 13 July

Re: [sqlite] [Windows] 3.13.0 recreate db from .dump file corrupts records with extended characters

2016-07-13 Thread Scott Robison
On Jul 13, 2016 11:14 AM, "Simon Slavin" wrote: > > > On 13 Jul 2016, at 5:22pm, Scott Robison wrote: > > > His program is not involved. Just the SQLite shell. > > He's feeding the shell with a pre-prepared file. Depending on how the OS command

Re: [sqlite] [Windows] 3.13.0 recreate db from .dump file corrupts records with extended characters

2016-07-13 Thread Simon Slavin
On 13 Jul 2016, at 6:26pm, Clemens Ladisch wrote: > To fix this, use the same mechanism for both output and input: > > sqlite3 old.db .dump > dump.sql > sqlite3 new.db < dump.sql > > or > > (echo .output dump.sql && echo .dump) | sqlite3 old.db > sqlite3 -init

Re: [sqlite] [Windows] 3.13.0 recreate db from .dump file corrupts records with extended characters

2016-07-13 Thread Clemens Ladisch
S.Ajina wrote: > Can confirm that sqlite3.exe version 3.8.6 works ok restoring database from a > .dump dump.sql file using these commands > > echo .dump | sqlite3_v3.8.6 test.original.db > dump_v3.8.6.sql > sqlite3_v3.8.6 -init dump_v3.8.6.sqltest.restored.v3.8.6.db > > Doing the

Re: [sqlite] [Windows] 3.13.0 recreate db from .dump file corrupts records with extended characters

2016-07-13 Thread Simon Slavin
On 13 Jul 2016, at 5:54pm, S.Ajina wrote: > SQLite version 3.13.0 2016-05-18 10:57:30 > Jap�n (2002)|4A6170C3B36E20283230303229 > 4A 61 70 C3 B3 6E 20283230303229 > SQLite version 3.8.6 2014-08-15 11:46:33 > Japón (2002)|4A6170C3B36E20283230303229 > 4A 61 70 C3 B3 6E

Re: [sqlite] [Windows] 3.13.0 recreate db from .dump file corrupts records with extended characters

2016-07-13 Thread Simon Slavin
On 13 Jul 2016, at 5:22pm, Scott Robison wrote: > His program is not involved. Just the SQLite shell. He's feeding the shell with a pre-prepared file. Depending on how the OS command shell works, the result may depend on the text encoding used for the contents of

Re: [sqlite] [Windows] 3.13.0 recreate db from .dump file corrupts records with extended characters

2016-07-13 Thread S.Ajina
-Original Message- From: sqlite-users-boun...@mailinglists.sqlite.org [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of Simon Slavin Sent: 13 July 2016 16:55 To: SQLite mailing list <sqlite-users@mailinglists.sqlite.org> Subject: Re: [sqlite] [Windows] 3.13.0 recreate db from .dump file cor

Re: [sqlite] [Windows] 3.13.0 recreate db from .dump file corrupts records with extended characters

2016-07-13 Thread Scott Robison
On Jul 13, 2016 9:55 AM, "Simon Slavin" wrote: > > > On 13 Jul 2016, at 4:09pm, S.Ajina wrote: > > > Doing the same with the current version of sqlite3.exe (version 3.13.0) corrupts the database records when there are extended characters > > I would

Re: [sqlite] [Windows] 3.13.0 recreate db from .dump file corrupts records with extended characters

2016-07-13 Thread Simon Slavin
On 13 Jul 2016, at 4:09pm, S.Ajina wrote: > Doing the same with the current version of sqlite3.exe (version 3.13.0) > corrupts the database records when there are extended characters I would guess that your program is handing extended characters to SQLite incorrectly.

[sqlite] [Windows] 3.13.0 recreate db from .dump file corrupts records with extended characters

2016-07-13 Thread S.Ajina
On windows platform, the following commands using windows command line prompt and sqlite3.exe worked with old versions of sqlite3.exe Can confirm that sqlite3.exe version 3.8.6 works ok restoring database from a .dump dump.sql file using these commands echo .dump | sqlite3_v3.8.6