Dominique, On Mon, Feb 8, 2016 at 11:43 AM, Dominique Devienne <ddevienne at gmail.com> wrote: > 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?);
Thank you. I will try it tonight when I get home. >> > _______________________________________________ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
