[sqlite] Version 3.11.0 beta

2016-02-11 Thread Olivier Mascia
. Name: signature.asc Type: application/pgp-signature Size: 842 bytes Desc: Message signed with OpenPGP using GPGMail URL: <http://mailinglists.sqlite.org/cgi-bin/mailman/private/sqlite-users/attachments/20160211/248c8cb9/attachment.pgp>

[sqlite] Version 3.11.0 beta

2016-02-11 Thread Olivier Mascia
nt was scrubbed... Name: signature.asc Type: application/pgp-signature Size: 842 bytes Desc: Message signed with OpenPGP using GPGMail URL: <http://mailinglists.sqlite.org/cgi-bin/mailman/private/sqlite-users/attachments/20160211/360fea94/attachment.pgp>

[sqlite] Version 3.11.0 beta

2016-02-11 Thread Dominique Devienne
On Thu, Feb 11, 2016 at 1:10 PM, Olivier Mascia wrote: > > Le 11 f?vr. 2016 ? 10:48, Olivier Mascia a ?crit : > > It looks like the appropriate character set mapping behavior on Windows > is still not quite right in the command line utility. > > If I'm changing shell.c (utf8_printf) to use some

[sqlite] unixCurrentTime being aliased to NULL cause crashes with custom VFS v1 implementation

2016-02-11 Thread Richard Hipp
On 2/10/16, Even Rouault wrote: > > Starting with SQLite 3.10.0, the unixCurrentTime function is now aliased to > the NULL pointer. > Changed back for 3.11.0. See the 4th bullet under "Bug Fixes" at https://www.sqlite.org/draft/releaselog/3_11_0.html -- D. Richard Hipp drh at sqlite.org

[sqlite] Version 3.11.0 beta

2016-02-11 Thread Clemens Ladisch
Dominique Devienne wrote: > On Thu, Feb 11, 2016 at 1:10 PM, Olivier Mascia wrote: >>> Le 11 f?vr. 2016 ? 10:48, Olivier Mascia a ?crit : >>> It looks like the appropriate character set mapping behavior on Windows >> is still not quite right in the command line utility. >> >> If I'm changing

[sqlite] SQLite?

2016-02-11 Thread Stephen Chrzanowski
You'll need to write your own routines to do that. There is no way to sync directly, such as 1:1 replication. The best you can hope for is to write an api that tells MySQL to do particular updates. If you want two way sync, then your app will not only need to listen for inbound, or at least

[sqlite] Unicode issue on windows consoles. Was: Version 3.11.0 beta

2016-02-11 Thread Richard Hipp
On 2/11/16, Clemens Ladisch wrote: > Dominique Devienne wrote: >> On Thu, Feb 11, 2016 at 1:10 PM, Olivier Mascia wrote: >>> >>> If I'm changing shell.c (utf8_printf) to use some >>> sqlite3_win32_utf8_to_oem() (which is the same as >>> sqlite3_win32_utf8_to_mbcs, but always use CP_OEMCP) AND

[sqlite] Unicode issue on windows consoles. Was: Version 3.11.0 beta

2016-02-11 Thread Olivier Mascia
<http://mailinglists.sqlite.org/cgi-bin/mailman/private/sqlite-users/attachments/20160211/edf27d0f/attachment.pgp>

[sqlite] Unicode issue on windows consoles. Was: Version 3.11.0 beta

2016-02-11 Thread Stephan Beal
On Thu, Feb 11, 2016 at 4:46 PM, Olivier Mascia wrote: > The way I patched it works nicely for the interactivity, but more work > needs to be done for handling the command-line itself properly (it always > is ANSI - or Wide and not OEM-something or UTF-8). In addition my code will > need deep

[sqlite] Unicode issue on windows consoles. Was: Version 3.11.0 beta

2016-02-11 Thread Dominique Devienne
On Thu, Feb 11, 2016 at 5:07 PM, Stephan Beal wrote: > You might want to look at: > > https://www.fossil-scm.org/index.html/finfo?name=src/utf8.c Interesting. Thanks for sharing. fossil_utf8_to_console() does seem to be WriteConsoleW-based, when the http://www.siao2.com

[sqlite] Unicode issue on windows consoles. Was: Version 3.11.0 beta

2016-02-11 Thread Olivier Mascia
-bin/mailman/private/sqlite-users/attachments/20160211/f678b95f/attachment.pgp>

[sqlite] Unicode issue on windows consoles. Was: Version 3.11.0 beta

2016-02-11 Thread Olivier Mascia
... Name: signature.asc Type: application/pgp-signature Size: 842 bytes Desc: Message signed with OpenPGP using GPGMail URL: <http://mailinglists.sqlite.org/cgi-bin/mailman/private/sqlite-users/attachments/20160211/f15ade0d/attachment.pgp>

[sqlite] dizzying error on my part

2016-02-11 Thread gMaj
to most, i prob did a dumb thing. to this sqLite nubie, seemed. natural thing to do. sadly, as it turns out. i tried to simply find and replace text in a database thats used in an inventory program... by opening the db in a word-processr, save. that all worked fine but now the program

[sqlite] dizzying error on my part

2016-02-11 Thread R Smith
So let me get this straight... You opened an sqlite database file in a word processor, then did find and replace, and saved it? I hope you have a backup of that database file If you do have a backup, we can teach you how to search and replace using an actual DB tool and SQL, else yes, you

[sqlite] dizzying error on my part

2016-02-11 Thread Simon Slavin
On 11 Feb 2016, at 5:16pm, gMaj wrote: > i tried to simply find and replace > text in a database thats used in an inventory > program... by opening the db in a word-processr, > save. that all worked fine but now the program > itself wont get past its opening. some kind of > "assertion

[sqlite] Unicode issue on windows consoles. Was: Version 3.11.0 beta

2016-02-11 Thread Clemens Ladisch
Richard Hipp wrote: > If you can provide solid suggestions for how to deal with the > unicode issue on windows consoles within the next day or so, we might > be able to incorporate changes into 3.11.0. But beyond that, I think > we'll need to push this off until 3.12.0. > > If y'all think that