nchar columns not showing for an SQLite database table
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.
Comments
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);