On Mon, Feb 8, 2016 at 4:28 PM, Dominique Devienne <ddevienne at gmail.com>
wrote:

> On Mon, Feb 8, 2016 at 4:17 PM, Igor Korot <ikorot01 at gmail.com> wrote:
>
>> Now my question is: is it possible to enter a Unicode character
>>
>
> Yes. Just use the char() built-in function. --DD
>

Oh, by "SQLite table contains" you meant the "table name". Sorry, I
misunderstood.
OT, but below shows about unicode chars (German umlaut) in column values,
and not identifiers, FWIW. --DD

sqlite> create table t (c);
sqlite> insert into t values (char(220));
sqlite> select * from t;
??
sqlite> select length(c) from t;
1
sqlite> select length(cast (c as blob)) from t;
2
sqlite> select unicode(c) from t;
220

Reply via email to