In case it helps... In a command-prompt, ALT 156 (hold ALT while pressing 156 on the NUMERIC keypad) uses the current code-page (British pound sign - ? - for me). ?Using ALT 0163 (i.e. preceding the character-code with a zero) uses Unicode (also a ?).
I don't have an sqlite3 shell to hand to test with. Graham. Sent from Samsung Mobile -------- Original message -------- From: Dominique Devienne <ddevie...@gmail.com> Date: 08/02/2016 16:43 (GMT+00:00) To: SQLite mailing list <sqlite-users at mailinglists.sqlite.org> Subject: Re: [sqlite] How to enter Unicode character? On Mon, Feb 8, 2016 at 5:33 PM, Dominique Devienne <ddevienne at gmail.com> wrote: > On Mon, Feb 8, 2016 at 4:46 PM, Igor Korot <ikorot01 at gmail.com> wrote: > >> On Mon, Feb 8, 2016 at 10:36 AM, Dominique Devienne <ddevienne at gmail.com> >> wrote: >> What I mean is the following: >> >> sqlite> CREATE TABLE abc<ss>(); >> >> In that line '<ss>' should be the German character which look like the >> Greek letter "beta". >> ... > > In the good old DOS days I would probably just do ALT+NUMPAD2,2,0, >> but that will most likely won't work here. >> > > It does appear to work for me. I used > https://en.wikipedia.org/wiki/Code_page_437 as a guide. > > C:\Users\DDevienne>chcp > Active code page: 437 > > ALT129 (keep pressing ALT, then press successively on keypad 1, 2, 9) > C:\Users\DDevienne>echo ? > ? > > ALT225 > C:\Users\DDevienne>echo ? > ? > > C:\Users\DDevienne>sqlite3 > SQLite version 3.8.9 2015-04-08 12:16:33 > Enter ".help" for usage hints. > Connected to a transient in-memory database. > Use ".open FILENAME" to reopen on a persistent database. > sqlite> create table t? (c?); > sqlite> insert into t? (c?) values (char(220)); > sqlite> insert into t? (c?) values (?); > Error: no such column: ? > sqlite> insert into t? (c?) values ('?'); > sqlite> .header on > sqlite> select * from t?; > c? > ?? > ? > Sorry, slight copy/paste issue on the last message. there are two rows as expect, but only the second ALT129 entered Above I made the mistake of using char(220), which is the upper-case U umlaut. Below I use char(252) (Unicode code point), and ALT129 (Windows CP437), which are logically the same letter (lower-case u umlaut), but don't show up the same. (see https://en.wikipedia.org/wiki/%C3%9C) sqlite> create table t? (c?); sqlite> insert into t? (c?) values (char(252)); sqlite> insert into t? (c?) values ('?'); sqlite> .header on sqlite> select c?, length(c?), length(cast(c? as blob)), unicode(c?) from t?; c?|length(c?)|length(cast(c? as blob))|unicode(c?) ??|1|2|252 ?|1|1|129 sqlite> .schema > CREATE TABLE t? (c?); > _______________________________________________ sqlite-users mailing list sqlite-users at mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
