nchar columns not showing for an SQLite database table

EE_Kraig · March 2018

I have an SQLite table and in Visual Studio using the SQLite Toolbox Extension, all of my columns are shown just fine. In LinqPad, the nchar columns are not shown. The DateTime, Int, Decimal, and nvarchar columns are ok. The same table in an Azure database works too.

EE_Kraig · March 2018

Try this, works just fine.

CREATE TABLE test (
contact_id integer PRIMARY KEY,
txt1 text NOT NULL,
txt2 text NOT NULL);

Now try this, txt1 doesn't show.

CREATE TABLE test (
contact_id integer PRIMARY KEY,
txt1 nchar (8) NOT NULL,
txt2 text NOT NULL);

nchar columns not showing for an SQLite database table

Comments