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

  • 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);
Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!