Previous line, and I want to start over instead of completing the statement), or Some multi-line statement, when there's a typo in the no-longer-editable Up terminating the shell when I meant to cancel input to the current line (or SetConsoleCtrlHandler() when calling ReadConsoleW(). Handling of Ctrl-C on Windows a bit, i.e.
#SQLITE 3 WINDOWS 7 PATCH#
So something based on the linked patch could even be used to disarm the strict (In practice, because other error conditionsĪre unlikely, this is probably the same as fgets() returning an empty string,īut the latter does some special processing, for example for Ctrl-Z.) Returns TRUE but sets *lpNumberOfCharsRead to 0, and GetLastError() Mentioned in the reply (by me, when I was too lazy to register for a forumĪccount, I'm sorry) should be taken into account.Ĭalling directly into ReadConsoleW() (instead of fgets() provided by theĬRT) has the advantage that it's possible to intercept Ctrl-C, i.e. I've tested it, and I think it's well done and works quite well, but the points There was a patch to enable Unicode console input and output on Windows. What did I do wrong? And what else should be done to make sqlite3.exe working with unicode? Thank you!Īnd what else should be done to make sqlite3.exe working with unicode? I've tried both precompiled sqlite3.exe binary from sql.org and also self-compiled with MinGW/gcc (option -municode). Oher popular console apps as git and psql work with unicode input/output without problems. I've tried above with cmd.exe and with Windows Terminal. This also ensures that database itself is not corrupted.
When I try to open database from command-line sqlite3 test.db and then run query that expected to return unicode results I get garbage text instead.Īll GUI tools I've checked (DBeaver and SQlite Studio) work with the same database as expected, with correct input/output of unicode text. When I start sqlite3.exe in console and try to input unicode text the console hangs and I should terminate it (Ctrl + C). I've faced some strange behavior of sqlite shell.
#SQLITE 3 WINDOWS 7 WINDOWS 10#
I'm on US Windows 10 64-bit (1903) with non-english locale.
I cannot find a way to bring the shell (sqlite3.exe 3.37.1) to work with input/output of unicode text and look for assistance.
0 kommentar(er)
